pgsql-performance - December 2010

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 28 29 30

Dec. 1, 2010

Thread Author Time
Re: SELECT INTO large FKyed table is slow Mario Splivalo 00:00
Re: SELECT INTO large FKyed table is slow Pierre C 00:51
Re: Question about subselect/IN performance bricklen 01:32
Re: SELECT INTO large FKyed table is slow Joshua D. Drake 01:47
Re: BBU Cache vs. spindles 📎 Bruce Momjian 03:07
Re: BBU Cache vs. spindles Bruce Momjian 03:13
Re: BBU Cache vs. spindles Bruce Momjian 03:54
Re: SELECT INTO large FKyed table is slow Mario Splivalo 07:52
Re: SELECT INTO large FKyed table is slow Mario Splivalo 07:53
Re: BBU Cache vs. spindles Pierre C 08:12
Re: SELECT INTO large FKyed table is slow Pierre C 08:23
Re: SELECT INTO large FKyed table is slow Pierre C 08:43
Re: tidscan not work ? Pg 8.4.5 + WinXP pasman pasmański 11:38
Re: BBU Cache vs. spindles Bruce Momjian 13:48
Re: SELECT INTO large FKyed table is slow 📎 Mladen Gogala 16:34
Clarification, please Mladen Gogala 16:46
Re: Clarification, please Richard Broersma 16:57
Re: SELECT INTO large FKyed table is slow Mario Splivalo 17:00
Re: Clarification, please Mladen Gogala 17:06
Re: Clarification, please Kevin Grittner 17:13
Re: SELECT INTO large FKyed table is slow Mladen Gogala 17:15
Re: SELECT INTO large FKyed table is slow Kenneth Marshall 17:22
Re: SELECT INTO large FKyed table is slow Kevin Grittner 17:24
Re: SELECT INTO large FKyed table is slow Mladen Gogala 17:33
Re: SELECT INTO large FKyed table is slow Mladen Gogala 21:07
Re: SELECT INTO large FKyed table is slow Pierre C 21:43

Dec. 2, 2010

Thread Author Time
Re: SELECT INTO large FKyed table is slow Mario Splivalo 08:36
Re: SELECT INTO large FKyed table is slow Mario Splivalo 08:51
Re: SELECT INTO large FKyed table is slow Kevin Grittner 18:43
Multicore Postgres 9.0.1 issue - single transaction problem. Piotr Czekalski 21:04

Dec. 3, 2010

Thread Author Time
Re: Multicore Postgres 9.0.1 issue - single transaction problem. Scott Marlowe 07:21
PostBIX to monitor postgresql performaces Andrea Dalle Vacche 13:48
Re: executor stats / page reclaims Robert Haas 17:16
Re: CPUs for new databases Scott Carey 17:36
Re: problem with from_collapse_limit and joined views Kevin Grittner 20:32
Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 21:41

Dec. 4, 2010

Thread Author Time
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 06:20
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 09:20
Re: problem with from_collapse_limit and joined views 📎 Markus Schulz 10:24
Slow query to get last created row using CURRVAL Mathieu De Zutter 11:56
Re: Slow query to get last created row using CURRVAL Marti Raudsepp 12:35
Re: Slow query to get last created row using CURRVAL Mathieu De Zutter 12:49
Re: problem with from_collapse_limit and joined views Kevin Grittner 15:29
Re: Slow query to get last created row using CURRVAL Віталій Тимчишин 15:32
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 16:42
Re: problem with from_collapse_limit and joined views Tom Lane 16:59
Re: problem with from_collapse_limit and joined views Markus Schulz 18:20
Re: problem with from_collapse_limit and joined views Markus Schulz 18:46
Re: Update problem on large table felix 19:45
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 21:34
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Mladen Gogala 21:58
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 22:40
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Mladen Gogala 23:19
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Jochen Erwied 23:38

Dec. 5, 2010

Thread Author Time
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 11:06
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 11:10
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 11:14
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 16:56
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 20:14
Group commit and commit delay/siblings Rob Wultsch 20:40

Dec. 6, 2010

Thread Author Time
Re: Group commit and commit delay/siblings Jignesh Shah 02:30
Re: Group commit and commit delay/siblings Rob Wultsch 02:47
Re: Group commit and commit delay/siblings Jignesh Shah 03:03
Re: Group commit and commit delay/siblings Greg Smith 04:35
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 05:00
Re: Group commit and commit delay/siblings Jignesh Shah 07:27
Strange optimization - xmin,xmax compression :) pasman pasmański 14:30
Re: Performance under contention Robert Haas 17:10
Re: Group commit and commit delay/siblings Tom Lane 17:55
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane 18:03
Re: Performance under contention Robert Haas 19:07
Re: Update problem on large table bricklen 19:46
Re: Update problem on large table Jon Nelson 19:48
Re: Update problem on large table Josh Kupershmidt 20:24
Re: Update problem on large table Kenneth Marshall 20:26
Re: Update problem on large table felix 21:31
Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos 21:48

Dec. 7, 2010

Thread Author Time
Re: Performance under contention Jignesh Shah 02:59
Re: Performance under contention Jignesh Shah 03:03
Re: Group commit and commit delay/siblings Jignesh Shah 03:07
Re: Group commit and commit delay/siblings 📎 Greg Smith 04:52
Slow BLOBs restoring Vlad Arkhipov 08:36
Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 17:34
Re: Performance under contention Robert Haas 17:37
Re: Performance under contention Tom Lane 17:50
Re: Performance under contention Dave Crooke 18:00
Re: Performance under contention Ivan Voras 18:08
Re: Performance under contention Robert Haas 18:09
Re: Performance under contention Robert Haas 18:10
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner 18:11
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 18:13
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andres Freund 18:20
Re: Performance under contention Ivan Voras 18:21
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James 19:23
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 19:43
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Richard Broersma 19:56
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades 19:58
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kenneth Marshall 20:10
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Mladen Gogala 20:22
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson 20:23
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak 21:29
Re: Performance under contention Віталій Тимчишин 21:36
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James 21:53
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades 22:11
Re: Update problem on large table Josh Kupershmidt 22:25
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner 22:39
Re: Performance under contention Ivan Voras 22:43

Dec. 8, 2010

Thread Author Time
Re: Performance under contention Robert Haas 04:23
Re: Performance under contention Robert Haas 04:24
Re: Slow BLOBs restoring Vlad Arkhipov 08:50
Re: Performance under contention Tom Lane 14:34
Re: Slow BLOBs restoring Tom Lane 14:46
Tunning Postgres salima 16:53
hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 18:53
Re: Group commit and commit delay/siblings Simon Riggs 19:00
Re: hashed subplan 5000x slower than two sequential operations Shrirang Chitnis 19:05
Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 20:05
Re: hashed subplan 5000x slower than two sequential operations Marc Mamin 20:06
Re: hashed subplan 5000x slower than two sequential operations Marc Mamin 20:12
Re: hashed subplan 5000x slower than two sequential operations Tom Lane 20:12
Re: hashed subplan 5000x slower than two sequential operations Pavel Stehule 20:25
Re: hashed subplan 5000x slower than two sequential operations 📎 Bryce Nesbitt 20:31
Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt 20:33
Re: Performance under contention Robert Haas 21:09
Re: Performance under contention Tom Lane 22:02
Hardware recommendations Benjamin Krajmalnik 23:03
Re: Hardware recommendations Andy 23:26
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations alaricd 23:27
Re: Hardware recommendations John W Strange 23:31
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Pierre C 23:35

Dec. 9, 2010

Thread Author Time
Re: Hardware recommendations Marti Raudsepp 00:02
Re: Hardware recommendations Benjamin Krajmalnik 00:03
Re: Hardware recommendations Andy 00:23
Re: Performance under contention Robert Haas 01:41
Re: Hardware recommendations Scott Marlowe 02:28
Re: Slow BLOBs restoring Vlad Arkhipov 03:58
Re: Slow BLOBs restoring Vlad Arkhipov 04:05
libpq vs ODBC Divakar Singh 04:31
Re: libpq vs ODBC Alex Goncharov 05:01
Re: Hardware recommendations mark 05:17
Re: libpq vs ODBC Divakar Singh 05:17
Re: Slow BLOBs restoring Tom Lane 05:28
Re: libpq vs ODBC Alex Goncharov 05:51
Re: libpq vs ODBC Divakar Singh 06:39
Re: libpq vs ODBC Pavel Stehule 06:57
UNION and bad performance Olivier Pala 10:52
Re: Hardware recommendations Marti Raudsepp 12:09
Re: [PERFORM] Slow BLOBs restoring Robert Haas 13:05
Re: [PERFORM] Slow BLOBs restoring Tom Lane 14:50
Re: [PERFORM] Slow BLOBs restoring Tom Lane 15:05
Re: [PERFORM] Slow BLOBs restoring Robert Haas 15:56
Re: [PERFORM] Slow BLOBs restoring Andrew Dunstan 16:01

Dec. 10, 2010

Thread Author Time
Re: Hardware recommendations John W Strange 01:57
Re: libpq vs ODBC Pierre C 02:32
Re: Hardware recommendations alan bryan 06:38
Re: Hardware recommendations Andy 13:58
Re: Hardware recommendations Arjen van der Meijden 17:57
Re: Hardware recommendations Arjen van der Meijden 18:05
Re: Hardware recommendations Scott Marlowe 18:08
Re: Hardware recommendations Andy 19:27

Dec. 11, 2010

Thread Author Time
Re: Hardware recommendations Greg Smith 09:10
Re: Hardware recommendations Greg Smith 09:18
Re: UNION and bad performance Marc Mamin 10:27
Re: UNION and bad performance Andreas Kretschmer 13:45

Dec. 12, 2010

Thread Author Time
Re: UNION and bad performance pasman pasmański 13:12

Dec. 13, 2010

Thread Author Time
CPU bound Royce Ausburn 02:43
Re: SELECT INTO large FKyed table is slow Robert Haas 03:30
Re: CPU bound Craig Ringer 11:10
Re: CPU bound Josh Berkus 18:59
Re: Hardware recommendations Benjamin Krajmalnik 20:45
Re: CPU bound Royce Ausburn 21:03
Re: Tunning Postgres Robert Haas 23:06

Dec. 14, 2010

Thread Author Time
Re: Hardware recommendations mark 03:29
Re: Tunning Postgres Grzegorz Jaśkiewicz 07:30
Re: Help with bulk read performance Jim Nasby 07:54
Index Bloat - how to tell? John W Strange 14:47
Re: Index Bloat - how to tell? Plugge, Joe R. 14:54
Re: Help with bulk read performance Andy Colson 15:27
Re: Help with bulk read performance Jim Nasby 15:41
Re: Help with bulk read performance Andy Colson 15:51
Re: Help with bulk read performance Nick Matheson 16:07
Re: Index Bloat - how to tell? Mladen Gogala 16:21
Re: Help with bulk read performance Jim Nasby 16:39
Re: Index Bloat - how to tell? Dave Crooke 20:12
Re: Index Bloat - how to tell? Mark Kirkwood 22:20

Dec. 15, 2010

Thread Author Time
only one index is using, why? AI Rumman 06:56
Re: only one index is using, why? Marti Raudsepp 08:52
Problems with FTS Rauan Maemirov 13:56
performance libpq vs JDBC Werner Scholtes 14:51
Re: Help with bulk read performance 📎 Dan Schaffer 20:15

Dec. 16, 2010

Thread Author Time
Re: performance libpq vs JDBC Divakar Singh 08:10
Re: performance libpq vs JDBC Werner Scholtes 09:21
Re: performance libpq vs JDBC Divakar Singh 09:37
Re: performance libpq vs JDBC Werner Scholtes 09:41
Re: performance libpq vs JDBC Divakar Singh 09:48

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 28 29 30