pgsql-performance - October 2007

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 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 1, 2007

Thread Author Time
Re: sequence query performance issues Peter Koczan 19:23

Oct. 2, 2007

Thread Author Time
Re: Linux mis-reporting memory Decibel! 15:57
Re: Linux mis-reporting memory Scott Marlowe 16:51
performance of like queries Kevin Kempter 17:31
Re: Linux mis-reporting memory Adam Tauno Williams 18:37
Re: performance of like queries Joshua D. Drake 21:06
Re: performance of like queries Marcin Stępnicki 21:49
Re: performance of like queries Chris Browne 21:55
Newbie question about degraded performance on delete statement. Giulio Cesare Solaroli 21:55
Re: Newbie question about degraded performance on delete statement. Dan Langille 22:02
Re: Linux mis-reporting memory Decibel! 22:17
Re: Newbie question about degraded performance on delete statement. Greg Williamson 22:39

Oct. 3, 2007

Thread Author Time
Difference between Vacuum and Vacuum full Radhika S 01:45
Re: Difference between Vacuum and Vacuum full Scott Marlowe 01:55
Re: Difference between Vacuum and Vacuum full Rodrigo De León 01:56
Re: Difference between Vacuum and Vacuum full D'Arcy J.M. Cain 02:02
Re: Difference between Vacuum and Vacuum full Radhika S 03:05
Re: Newbie question about degraded performance on delete statement. Giulio Cesare Solaroli 06:56
Re: Newbie question about degraded performance on delete statement. (SOLVED) Giulio Cesare Solaroli 07:00
Query taking too long. Problem reading explain output. Henrik 08:03
Re: Query taking too long. Problem reading explain output. Michael Fuhr 13:31
Re: Query taking too long. Problem reading explain output. Tom Lane 14:15

Oct. 4, 2007

Thread Author Time
can't shrink relation Sabin Coanda 09:43
Re: can't shrink relation Sabin Coanda 09:46
Re: can't shrink relation Guillaume Cottenceau 10:11
Re: Query taking too long. Problem reading explain output. Henrik 10:15
Re: can't shrink relation Richard Huxton 10:34
Re: Query taking too long. Problem reading explain output. Alvaro Herrera 12:30
Tuning Help - What did I do wrong? Josh Trutwin 15:28
Re: Tuning Help - What did I do wrong? Scott Marlowe 16:19
Re: Tuning Help - What did I do wrong? Scott Marlowe 16:22
Re: Tuning Help - What did I do wrong? Josh Trutwin 17:00
Re: Tuning Help - What did I do wrong? Scott Marlowe 17:42
Partitioning in postgres - basic question Tore Lukashaugen 17:51
quickly getting the top N rows Ben 18:00
Re: quickly getting the top N rows Mark Lewis 18:10
Re: quickly getting the top N rows Bill Moran 18:14
Re: quickly getting the top N rows Andreas Kretschmer 18:22
Re: quickly getting the top N rows Ben 18:33
Re: quickly getting the top N rows Tom Lane 18:52
Re: Tuning Help - What did I do wrong? Kevin Grittner 19:03
Re: Tuning Help - What did I do wrong? Josh Trutwin 19:28
Re: quickly getting the top N rows Ben 19:52
Re: quickly getting the top N rows Simon Riggs 20:23
Re: quickly getting the top N rows Scott Marlowe 20:32
Re: quickly getting the top N rows Ben 20:34
Re: quickly getting the top N rows Scott Marlowe 20:35
Re: quickly getting the top N rows Richard Huxton 21:01
Re: quickly getting the top N rows Tom Lane 21:04
Re: Query taking too long. Problem reading explain output. Henrik 21:15
Re: quickly getting the top N rows Ben 21:16
Re: Query taking too long. Problem reading explain output. Alvaro Herrera 23:43

Oct. 5, 2007

Thread Author Time
Re: Partitioning in postgres - basic question Chris 05:19
Slow TSearch2 performance for table with 1 million documents. Benjamin Arai 07:50
Re: Slow TSearch2 performance for table with 1 million documents. Alban Hertroys 12:00
Problems with + 1 million record table Cláudia Macedo Amorim 14:34
Re: Problems with + 1 million record table Scott Marlowe 15:01
Re: Slow TSearch2 performance for table with 1 million documents. Tom Lane 15:12
Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. Oleg Bartunov 15:32
Re: Problems with + 1 million record table Arjen van der Meijden 16:38
Re: Problems with + 1 million record table Joshua D. Drake 17:45
Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. Benjamin Arai 22:57

Oct. 6, 2007

Thread Author Time
Re: Problems with + 1 million record table Shane Ambler 01:19
query plan worse after analyze Jeff Frost 02:02
Re: query plan worse after analyze Stephen Frost 03:14
Re: query plan worse after analyze Rodrigo De León 03:58
Re: query plan worse after analyze Jeff Frost 04:12
Re: query plan worse after analyze Tom Lane 05:50
Re: query plan worse after analyze Jeff Frost 06:41
Re: query plan worse after analyze Alvaro Herrera 15:11

Oct. 7, 2007

Thread Author Time
Apache2 PostgreSQL http authentication Jeffrey Brower 13:14
Re: Apache2 PostgreSQL http authentication A.M. 15:19
Re: query plan worse after analyze Richard Broersma Jr 16:06
Re: Apache2 PostgreSQL http authentication Jeffrey Brower 19:07
Re: Apache2 PostgreSQL http authentication Jeffrey Brower 20:28
Re: Apache2 PostgreSQL http authentication D'Arcy J.M. Cain 20:44
Re: Apache2 PostgreSQL http authentication Jeffrey Brower 20:58

Oct. 8, 2007

Thread Author Time
Re: Apache2 PostgreSQL http authentication Jeffrey Brower 00:29
Re: Apache2 PostgreSQL http authentication Magnus Hagander 06:12
postgresql on NFS.. recommended? not recommended? Gábor Farkas 12:39
Re: postgresql on NFS.. recommended? not recommended? Josh Tolley 13:43
Re: Apache2 PostgreSQL http authentication Tino Wildenhain 17:09
Re: Apache2 PostgreSQL http authentication Magnus Hagander 17:12

Oct. 9, 2007

Thread Author Time
SQL Monitoring Campbell, Lance 14:11
Re: SQL Monitoring Marcin Stępnicki 14:36
Re: SQL Monitoring Heikki Linnakangas 15:07
Re: SQL Monitoring Gregory Stark 19:00
Postgres running Very slowly Radhika S 20:00
hashjoin chosen over 1000x faster plan Kevin Grittner 20:09
Shared Buffer setting in postgresql.conf Radhika S 20:12
Re: Postgres running Very slowly Bill Moran 20:18

Oct. 10, 2007

Thread Author Time
Re: Shared Buffer setting in postgresql.conf Marcin Stępnicki 05:25
Re: hashjoin chosen over 1000x faster plan Simon Riggs 06:31
Re: SQL Monitoring Tomáš Vondra 10:41
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 14:15
Performance problems with prepared statements Theo Kramer 14:45
Re: SQL Monitoring Rodrigo De León 14:58
Re: Performance problems with prepared statements Cédric Villemain 15:00
Re: Shared Buffer setting in postgresql.conf Scott Marlowe 15:20
Re: hashjoin chosen over 1000x faster plan Simon Riggs 17:05
Re: SQL Monitoring Josh Trutwin 17:25
Re: hashjoin chosen over 1000x faster plan Tom Lane 18:07
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 18:30
Re: hashjoin chosen over 1000x faster plan Simon Riggs 18:54
Re: hashjoin chosen over 1000x faster plan Simon Riggs 19:01
Re: Performance problems with prepared statements Theo Kramer 19:34
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 19:35
Re: hashjoin chosen over 1000x faster plan Simon Riggs 19:52
Re: Performance problems with prepared statements Jonah H. Harris 19:55
Re: Performance problems with prepared statements Theo Kramer 20:08
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 20:11
Re: Shared Buffer setting in postgresql.conf Josh Trutwin 20:32
Re: hashjoin chosen over 1000x faster plan Tom Lane 20:32
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 20:48
Re: Shared Buffer setting in postgresql.conf Scott Marlowe 20:58
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 21:02
Re: hashjoin chosen over 1000x faster plan Tom Lane 22:08
Re: hashjoin chosen over 1000x faster plan Kevin Grittner 22:09
building a performance test suite Kevin Kempter 22:21

Oct. 11, 2007

Thread Author Time
Re: Shared Buffer setting in postgresql.conf Radhika S 00:33
Re: Shared Buffer setting in postgresql.conf Scott Marlowe 00:49
Re: building a performance test suite Greg Smith 03:14
Re: Query taking too long. Problem reading explain output. Ow Mun Heng 03:16
Re: Performance problems with prepared statements Cédric Villemain 08:51
Re: building a performance test suite Dimitri Fontaine 08:52
Re: Performance problems with prepared statements Richard Huxton 09:12
Re: Performance problems with prepared statements Theo Kramer 10:33
Huge amount of memory consumed during transaction henk de wit 14:04
Re: Huge amount of memory consumed during transaction Richard Huxton 14:16
Re: Huge amount of memory consumed during transaction Scott Marlowe 14:27
Re: Huge amount of memory consumed during transaction Tom Lane 14:51
Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. Benjamin Arai 14:52
Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. Tom Lane 15:53
Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. Benjamin Arai 16:12
Re: Huge amount of memory consumed during transaction Erik Jones 16:51
Re: Performance problems with prepared statements Merlin Moncure 17:28
Re: Huge amount of memory consumed during transaction Tom Lane 17:49
Re: Performance problems with prepared statements Andrew - Supernews 18:28
Re: Performance problems with prepared statements Merlin Moncure 20:04
Re: Huge amount of memory consumed during transaction henk de wit 23:21
Re: Huge amount of memory consumed during transaction henk de wit 23:23

Oct. 12, 2007

Thread Author Time
Re: Huge amount of memory consumed during transaction Tom Lane 01:26
Re: Performance problems with prepared statements Theo Kramer 07:35
Re: Performance problems with prepared statements Theo Kramer 07:38
Re: Performance problems with prepared statements Theo Kramer 08:05
Re: Performance problems with prepared statements Richard Huxton 08:26
Re: Performance problems with prepared statements Merlin Moncure 13:02
Re: Performance problems with prepared statements Theo Kramer 14:57
Re: Performance problems with prepared statements Kevin Grittner 19:03
Re: Huge amount of memory consumed during transaction Tom Lane 19:59
How to speed up min/max(id) in 50M rows table? henk de wit 20:41
Re: How to speed up min/max(id) in 50M rows table? Kevin Grittner 20:53
Re: How to speed up min/max(id) in 50M rows table? henk de wit 20:59
Re: Huge amount of memory consumed during transaction henk de wit 21:09
Re: How to speed up min/max(id) in 50M rows table? henk de wit 21:19
Re: Huge amount of memory consumed during transaction Erik Jones 21:39
Re: How to speed up min/max(id) in 50M rows table? henk de wit 21:40
Re: Huge amount of memory consumed during transaction henk de wit 21:48
Re: How to speed up min/max(id) in 50M rows table? Tom Lane 22:03
Re: How to speed up min/max(id) in 50M rows table? Alan Hodgson 22:04
Re: Huge amount of memory consumed during transaction Erik Jones 22:13
Re: How to speed up min/max(id) in 50M rows table? Tom Lane 22:17
Re: How to speed up min/max(id) in 50M rows table? henk de wit 22:21
Re: How to speed up min/max(id) in 50M rows table? Tom Lane 22:51
Re: How to speed up min/max(id) in 50M rows table? henk de wit 23:13
Re: How to speed up min/max(id) in 50M rows table? henk de wit 23:48

Oct. 15, 2007

Thread Author Time
using a stored proc that returns a result set in a complex SQL stmt chrisj 16:09

Oct. 16, 2007

Thread Author Time
Vacuum goes worse Stéphane Schildknecht 08:48
Re: Vacuum goes worse Heikki Linnakangas 09:08
Re: Vacuum goes worse Stéphane Schildknecht 09:50
Autovacuum running out of memory Jason Lustig 11:12
Re: Autovacuum running out of memory Richard Huxton 11:45
Re: Autovacuum running out of memory Jason Lustig 11:55
Re: Autovacuum running out of memory Richard Huxton 12:23
Re: Autovacuum running out of memory Jason Lustig 13:32
Re: Autovacuum running out of memory Richard Huxton 14:01
Re: Autovacuum running out of memory Scott Marlowe 14:08
Re: Autovacuum running out of memory Jason Lustig 14:14
Re: Autovacuum running out of memory Richard Huxton 14:22
Re: Autovacuum running out of memory Scott Marlowe 14:22
Re: Vacuum goes worse Tom Lane 14:26
Re: Autovacuum running out of memory Mark Lewis 14:33
Re: Autovacuum running out of memory Jason Lustig 14:54
Re: Autovacuum running out of memory Rodrigo Gonzalez 15:00
Re: Autovacuum running out of memory Tom Lane 15:10
Re: using a stored proc that returns a result set in a complex SQL stmt Heikki Linnakangas 15:22
Re: Vacuum goes worse Stéphane Schildknecht 15:26
Re: Vacuum goes worse Tom Lane 15:30
Re: Autovacuum running out of memory Tom Lane 15:38
Re: Vacuum goes worse Scott Marlowe 15:43
Re: Autovacuum running out of memory 李彦 Ian Li 16:00
Re: Vacuum goes worse Tom Lane 16:03

Oct. 17, 2007

Thread Author Time
Re: Vacuum goes worse Brian Herlihy 00:03
Re: Vacuum goes worse Tom Lane 01:16
Re: Vacuum goes worse Joshua D. Drake 03:19
Re: using a stored proc that returns a result set in a complex SQL stmt Marcin Stępnicki 05:32
Re: Vacuum goes worse Stéphane Schildknecht 11:33
two queryes in a single tablescan Stefano Dal Pra 12:30
Re: two queryes in a single tablescan Heikki Linnakangas 13:00
Re: two queryes in a single tablescan Steinar H. Gunderson 13:15

Browse Archives

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