pgsql-performance since 2010-11-25 00:00

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

Nov. 25, 2010

Thread Author Time
Which gives good performance? separate database vs separate schema Divakar Singh 11:37
Re: Which gives good performance? separate database vs separate schema tv 12:02
Re: Which gives good performance? separate database vs separate schema Thomas Kellerer 12:03
Re: Which gives good performance? separate database vs separate schema tv 12:09
Re: Which gives good performance? separate database vs separate schema Andres Freund 12:10
Re: Which gives good performance? separate database vs separate schema tv 12:25
Re: Performance under contention Ivan Voras 12:39
Re: Which gives good performance? separate database vs separate schema Divakar Singh 14:53
Re: Which gives good performance? separate database vs separate schema tv 15:46

Nov. 26, 2010

Thread Author Time
Re: Performance under contention Greg Smith 02:00
Re: Performance under contention Ivan Voras 02:08
Re: Optimizing query Pierre C 09:46
Re: Which gives good performance? separate database vs separate schema Robert Klemme 11:38
Update problem on large table felix 14:22
Re: Optimizing query pasman pasmański 15:06
Re: Update problem on large table bricklen 16:00
Re: CPUs for new databases Christian Elmerot @ One.com 16:38
Re: CPUs for new databases Kevin Grittner 17:46
Re: CPUs for new databases Greg Smith 22:30

Nov. 28, 2010

Thread Author Time
SELECT INTO large FKyed table is slow Mario Splivalo 11:46
Simple database, multiple instances? Mario Splivalo 12:02
Re: SELECT INTO large FKyed table is slow Pierre C 18:56
Re: SELECT INTO large FKyed table is slow Mario Splivalo 19:08
Re: SELECT INTO large FKyed table is slow Pierre C 21:50

Nov. 29, 2010

Thread Author Time
Hi- Sleeptime reduction aaliya zarrin 04:39
Re: Hi- Sleeptime reduction Kevin Grittner 05:09
Full Text index is not using during OR operation AI Rumman 07:00
Re: SELECT INTO large FKyed table is slow Mark Kirkwood 07:11
Re: SELECT INTO large FKyed table is slow Mario Splivalo 12:23
Re: SELECT INTO large FKyed table is slow Mario Splivalo 12:30
Re: Full Text index is not using during OR operation Oleg Bartunov 12:37
Re: Full Text index is not using during OR operation AI Rumman 14:03
Re: Full Text index is not using during OR operation Tobias Brox 14:32
Re: Full Text index is not using during OR operation Oleg Bartunov 15:02
Re: SELECT INTO large FKyed table is slow Pierre C 16:47
Re: SELECT INTO large FKyed table is slow Pierre C 16:53

Nov. 30, 2010

Thread Author Time
Re: MVCC performance issue Robert Haas 00:21
postgresql statements are waiting bakkiya 11:38
tidscan not work ? Pg 8.4.5 + WinXP pasman pasmański 11:43
Re: Simple database, multiple instances? Dimitri Fontaine 11:45
Re: Simple database, multiple instances? Mario Splivalo 12:31
Re: SELECT INTO large FKyed table is slow Mladen Gogala 16:26
Re: tidscan not work ? Pg 8.4.5 + WinXP Kevin Grittner 16:44
Re: tidscan not work ? Pg 8.4.5 + WinXP Tom Lane 16:49
Re: postgresql statements are waiting Kevin Grittner 16:52
Re: postgresql statements are waiting Scott Marlowe 16:54
Re: Simple database, multiple instances? Maciek Sakrejda 17:16
Question about subselect/IN performance T.H. 17:43
Re: Simple database, multiple instances? Pierre C 22:35
Re: Question about subselect/IN performance Kevin Grittner 22:54
Re: SELECT INTO large FKyed table is slow Mario Splivalo 23:22
Re: Question about subselect/IN performance T.H. 23:23
Re: SELECT INTO large FKyed table is slow Mario Splivalo 23:24
Re: SELECT INTO large FKyed table is slow Mark Kirkwood 23:50

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

Browse Archives

Prev | Next