Mailing lists [pgsql-performance]

1 October 2007

• 19:23   Re: sequence query performance issues Peter Koczan

2 October 2007

• 16:42   Re: Linux mis-reporting memory Decibel!
• 16:51   Re: Linux mis-reporting memory Scott Marlowe
• 18:37   Re: Linux mis-reporting memory Adam Tauno Williams
• 21:00   performance of like queries Kevin Kempter
• 21:05   Re: performance of like queries Joshua D. Drake
• 21:49   Re: performance of like queries Marcin Stępnicki
• 21:55   Newbie question about degraded performance on delete statement. Giulio Cesare Solaroli
• 22:02   Re: Newbie question about degraded performance on delete statement. Dan Langille
• 22:18   Re: Linux mis-reporting memory Decibel!
• 22:23   Re: performance of like queries Chris Browne
• 22:40   Re: Newbie question about degraded performance on delete statement. Greg Williamson

3 October 2007

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

4 October 2007

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

5 October 2007

• 05:16   Re: Partitioning in postgres - basic question Chris
• 08:10   Slow TSearch2 performance for table with 1 million documents. Benjamin Arai
• 14:39   Problems with + 1 million record table Cláudia Macedo Amorim
• 15:02   Re: Problems with + 1 million record table Scott Marlowe
• 15:13   Re: [GENERAL] Slow TSearch2 performance for table with 1 million documents. Tom Lane
• 15:32   Re: [GENERAL] Slow TSearch2 performance for table with 1 million documents. Oleg Bartunov
• 16:38   Re: Problems with + 1 million record table Arjen van der Meijden
• 17:44   Re: Problems with + 1 million record table Joshua D. Drake
• 22:58   Re: [GENERAL] Slow TSearch2 performance for table with 1 million documents. Benjamin Arai

6 October 2007

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

7 October 2007

• 13:15   Apache2 PostgreSQL http authentication Jeffrey Brower
• 15:51   Re: Apache2 PostgreSQL http authentication A.M.
• 16:06   Re: query plan worse after analyze Richard Broersma Jr
• 19:08   Re: Apache2 PostgreSQL http authentication Jeffrey Brower
• 20:29   Re: Apache2 PostgreSQL http authentication Jeffrey Brower
• 20:45   Re: Apache2 PostgreSQL http authentication D'Arcy J.M. Cain
• 21:03   Re: Apache2 PostgreSQL http authentication Jeffrey Brower

8 October 2007

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

9 October 2007

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

10 October 2007

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

11 October 2007

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

12 October 2007

• 01:27   Re: Huge amount of memory consumed during transaction Tom Lane
• 07:35   Re: Performance problems with prepared statements Theo Kramer
• 07:38   Re: Performance problems with prepared statements Theo Kramer
• 08:06   Re: Performance problems with prepared statements Theo Kramer
• 08:26   Re: Performance problems with prepared statements Richard Huxton
• 13:06   Re: Performance problems with prepared statements Merlin Moncure
• 14:57   Re: Performance problems with prepared statements Theo Kramer
• 19:04   Re: Performance problems with prepared statements Kevin Grittner
• 20:00   Re: Huge amount of memory consumed during transaction Tom Lane
• 20:42   How to speed up min/max(id) in 50M rows table? henk de wit
• 20:54   Re: How to speed up min/max(id) in 50M rows table? Kevin Grittner
• 20:59   Re: How to speed up min/max(id) in 50M rows table? henk de wit
• 21:10   Re: Huge amount of memory consumed during transaction henk de wit
• 21:19   Re: How to speed up min/max(id) in 50M rows table? henk de wit
• 21:39   Re: Huge amount of memory consumed during transaction Erik Jones
• 21:42   Re: How to speed up min/max(id) in 50M rows table? henk de wit
• 21:49   Re: Huge amount of memory consumed during transaction henk de wit
• 22:04   Re: How to speed up min/max(id) in 50M rows table? Tom Lane
• 22:04   Re: How to speed up min/max(id) in 50M rows table? Alan Hodgson
• 22:13   Re: Huge amount of memory consumed during transaction Erik Jones
• 22:17   Re: How to speed up min/max(id) in 50M rows table? Tom Lane
• 22:22   Re: How to speed up min/max(id) in 50M rows table? henk de wit
• 22:51   Re: How to speed up min/max(id) in 50M rows table? Tom Lane
• 23:14   Re: How to speed up min/max(id) in 50M rows table? henk de wit
• 23:48   Re: How to speed up min/max(id) in 50M rows table? henk de wit

16 October 2007

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

17 October 2007

• 00:10   Re: Vacuum goes worse Brian Herlihy
• 01:16   Re: Vacuum goes worse Tom Lane
• 03:19   Re: Vacuum goes worse Joshua D. Drake
• 05:32   Re: using a stored proc that returns a result set in a complex SQL stmt Marcin Stępnicki
• 11:33   Re: Vacuum goes worse Stéphane Schildknecht
• 12:37   two queryes in a single tablescan Stefano Dal Pra
• 13:02   Re: two queryes in a single tablescan Heikki Linnakangas
• 13:15   Re: two queryes in a single tablescan Steinar H. Gunderson
• 13:22   Re: two queryes in a single tablescan Stefano Dal Pra
• 13:41   Re: two queryes in a single tablescan Heikki Linnakangas
• 13:43   Re: Vacuum goes worse Alvaro Herrera
• 14:35   Re: Vacuum goes worse Stefano Dal Pra
• 15:53   Re: Vacuum goes worse Tom Lane
• 15:56   Re: Vacuum goes worse Tom Lane
• 16:07   Re: Vacuum goes worse Alvaro Herrera
• 18:07   Incorrect estimates on columns Chris Kratz
• 18:44   Re: Vacuum goes worse Scott Marlowe
• 18:49   Re: Incorrect estimates on columns Tom Lane
• 19:46   Re: Incorrect estimates on columns Chris Kratz
• 21:10   Re: Huge amount of memory consumed during transaction Alvaro Herrera
• 23:28   Re: Huge amount of memory consumed during transaction Tom Lane

18 October 2007

• 00:23   Re: Incorrect estimates on columns Tom Lane
• 01:34   Re: Shared Buffer setting in postgresql.conf Ow Mun Heng
• 02:32   Re: two queryes in a single tablescan 李彦 Ian Li
• 06:17   Re: Vacuum goes worse Stéphane Schildknecht
• 06:20   Re: Vacuum goes worse Stéphane Schildknecht
• 09:29   Re: Incorrect estimates on columns Nis Jørgensen
• 17:21   How to improve speed of 3 table join &group (HUGE tables) John Major
• 18:58   Re: How to improve speed of 3 table join &group (HUGE tables) Nis Jørgensen
• 19:07   Re: How to improve speed of 3 table join &group (HUGE tables) Heikki Linnakangas
• 19:47   Re: How to improve speed of 3 table join &group (HUGE tables) John Major
• 20:05   Re: How to improve speed of 3 table join &group (HUGE tables) John Major
• 20:06   Re: Incorrect estimates on columns Chris Kratz

19 October 2007

• 05:17   Re: How to improve speed of 3 table join &group (HUGE tables) ismo.tuononen@solenovo.fi
• 11:57   how to improve the performance of creating index Yinan Li
• 12:05   Re: how to improve the performance of creating index Heikki Linnakangas
• 13:06   Re: how to improve the performance of creating index Chris Browne
• 14:51   Re: how to improve the performance of creating index Heikki Linnakangas
• 15:05   need help with a query Pavel Velikhov
• 15:53   Re: need help with a query Jonah H. Harris
• 16:11   Re: need help with a query Pavel Velikhov
• 16:34   Re: need help with a query Tom Lane
• 18:21   Re: how to improve the performance of creating index Scott Marlowe

20 October 2007

• 16:31   Re: [SQL] two queryes in a single tablescan Markus Schaber
• 17:14   Re: [SQL] two queryes in a single tablescan Andreas Kretschmer
• 20:11   Re: need help with a query Pavel Velikhov
• 22:02   Re: [SQL] two queryes in a single tablescan Erik Jones

21 October 2007

• 16:44   Re: need help with a query Jonah H. Harris

22 October 2007

• 16:11   Memory Settings.... Lee Keel
• 17:15   Re: Memory Settings.... Peter Koczan
• 17:24   Re: Memory Settings.... Ben
• 17:31   Re: Memory Settings.... Heikki Linnakangas
• 17:34   Re: Memory Settings.... Kevin Grittner

23 October 2007

• 02:24   Seqscan Adrian Demaestri
• 02:42   Re: Seqscan Jeff Davis
• 09:54   Re: need help with a query Pavel Velikhov
• 11:18   Re: How to improve speed of 3 table join &group (HUGE tables) Nis Jørgensen
• 13:06   Re: Seqscan Adrian Demaestri
• 13:36   Re: Seqscan Nis Jørgensen
• 15:57   12 hour table vacuums Ron St-Pierre
• 16:08   Re: 12 hour table vacuums Bill Moran
• 16:12   Re: 12 hour table vacuums Tom Lane
• 16:12   Re: 12 hour table vacuums Alvaro Herrera
• 16:21   Re: 12 hour table vacuums Csaba Nagy
• 16:36   Re: 12 hour table vacuums Ron St-Pierre
• 16:38   Re: 12 hour table vacuums Gregory Stark
• 16:41   Re: 12 hour table vacuums Bill Moran
• 16:47   Re: 12 hour table vacuums Ron St-Pierre
• 16:56   Re: 12 hour table vacuums Ron St-Pierre
• 17:03   Re: 12 hour table vacuums Ron St-Pierre
• 17:41   Re: 12 hour table vacuums Joshua D. Drake
• 18:04   Re: 12 hour table vacuums Simon Riggs
• 18:27   Re: 12 hour table vacuums Alvaro Herrera
• 18:28   Re: 12 hour table vacuums Alvaro Herrera

24 October 2007

• 09:10   Re: 12 hour table vacuums Harald Fuchs
• 10:44   Finalizing commit taking very long Giulio Cesare Solaroli
• 12:48   multiple apaches against single postgres database Honza Novak
• 13:15   Re: multiple apaches against single postgres database Michal Taborsky - Internet Mall
• 13:16   Re: Finalizing commit taking very long Tom Lane
• 13:16   Re: 12 hour table vacuums Jean-David Beyer
• 13:17   Re: multiple apaches against single postgres database Gregory Stark
• 13:37   Re: Finalizing commit taking very long Giulio Cesare Solaroli
• 14:03   Re: Finalizing commit taking very long Tom Lane
• 14:28   Re: Finalizing commit taking very long Giulio Cesare Solaroli
• 14:58   Re: multiple apaches against single postgres database Sven Geisler
• 17:22   Re: multiple apaches against single postgres database Kevin Grittner

25 October 2007

• 03:28   Re: multiple apaches against single postgres database Tatsuo Ishii
• 15:44   Bunching "transactions" Jean-David Beyer
• 16:00   Re: Bunching "transactions" Erik Jones
• 16:11   Re: Bunching "transactions" Heikki Linnakangas
• 16:22   Re: Bunching "transactions" Tom Lane
• 18:07   Re: Bunching "transactions" Chris Browne
• 19:20   Re: Bunching "transactions" Jean-David Beyer
• 20:25   8.3beta1 testing on Solaris Jignesh K. Shah
• 20:36   PostgreSQL 8.3beta1 on Solaris testing case study Jignesh K. Shah
• 20:54   Re: [HACKERS] 8.3beta1 testing on Solaris Tom Lane
• 21:07   Re: Bunching "transactions" Chris Browne
• 22:38   Re: 8.3beta1 testing on Solaris Gregory Stark
• 22:44   Re: [HACKERS] 8.3beta1 testing on Solaris Gregory Stark

26 October 2007

• 00:51   Re: [HACKERS] 8.3beta1 testing on Solaris Tom Lane
• 02:55   Re: [HACKERS] 8.3beta1 testing on Solaris Josh Berkus
• 03:26   Re: [HACKERS] 8.3beta1 testing on Solaris Tom Lane
• 08:08   Re: [HACKERS] 8.3beta1 testing on Solaris Gregory Stark
• 12:43   Re: Finalizing commit taking very long Giulio Cesare Solaroli
• 13:05   Re: Bunching "transactions" Jean-David Beyer
• 13:20   Re: 8.3beta1 testing on Solaris Jignesh K. Shah
• 13:25   Re: [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah
• 13:37   Re: [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah
• 14:13   Re: Bunching "transactions" Jean-David Beyer
• 15:08   Re: Bunching "transactions" Greg Smith
• 15:45   Re: [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah
• 16:46   Re: [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah
• 19:08   Re: [HACKERS] 8.3beta1 testing on Solaris Tom Lane
• 20:26   Suggestions on an update query Campbell, Lance
• 20:31   Re: Suggestions on an update query Campbell, Lance
• 20:44   Speed difference between select ... union select ... and select from partitioned_table Pablo Alcaraz
• 21:07   Re: Speed difference between select ... union select ... and select from partitioned_table Jeff Davis
• 21:10   Re: Suggestions on an update query Gregory Stark
• 21:11   Re: Speed difference between select ... union select ... and select from partitioned_table Pablo Alcaraz
• 21:13   Re: Speed difference between select ... union select ... and select from partitioned_table Gregory Stark
• 21:15   Re: Suggestions on an update query Joshua D. Drake
• 21:45   Re: [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah

27 October 2007

• 02:04   Re: Suggestions on an update query Gregory Stark
• 02:31   Re: Suggestions on an update query Joshua D. Drake
• 04:26   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 05:16   Re: Speed difference between select ... union select ... and select from partitioned_table Pablo Alcaraz
• 05:37   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Tom Lane
• 08:53   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 09:17   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
• 13:17   Re: Speed difference between select ... union select ... and select from partitioned_table Tom Lane
• 19:11   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 19:27   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 21:28   Re: Speed difference between select ... union select ... and select from partitioned_table Simon Riggs
• 21:33   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Simon Riggs
• 21:47   Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1 Luke Lonergan
• 22:31   Re: Speed difference between select ... union select ... and select from partitioned_table Pablo Alcaraz

28 October 2007

• 00:20   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark
• 09:15   Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1 Simon Riggs
• 15:22   Append Cost in query planners Nimesh Satam
• 15:38   Re: Append Cost in query planners Heikki Linnakangas
• 16:54   Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1 Tom Lane
• 17:29   Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1 Simon Riggs
• 18:22   Re: Append Cost in query planners Heikki Linnakangas
• 21:25   Outer joins and Seq scans Sami Dalouche
• 22:08   Re: Outer joins and Seq scans Tom Lane
• 22:55   Re: Outer joins and Seq scans Sami Dalouche
• 23:45   Re: Outer joins and Seq scans Tom Lane

29 October 2007

• 09:48   Re: Outer joins and Seq scans Dimitri Fontaine
• 11:09   Re: Append Cost in query planners Nimesh Satam
• 11:12   Re: Outer joins and Seq scans Richard Huxton
• 11:40   Re: Append Cost in query planners Heikki Linnakangas
• 11:55   Re: Outer joins and Seq scans Cédric Villemain
• 11:56   Re: Append Cost in query planners Nimesh Satam
• 13:40   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark
• 15:22   Re: Append Cost in query planners Heikki Linnakangas
• 16:33   Re: Suggestions on an update query Campbell, Lance

30 October 2007

• 05:24   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 05:28   Re: Suggestions on an update query Scott Marlowe
• 05:46   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood
• 05:54   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Tom Lane
• 08:27   High Availability and Load Balancing ruben@rentalia.com
• 09:06   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark
• 12:38   Improving Query Ketema
• 13:23   Re: Improving Query Richard Huxton
• 13:28   Optimizing PostgreSQL for Windows Christian Rengstl
• 13:32   Re: Improving Query Michael Glaesemann
• 13:42   Re: Improving Query Ketema Harris
• 14:16   Re: Improving Query Ketema Harris
• 14:19   Re: Optimizing PostgreSQL for Windows Marc Schablewski
• 15:39   Re: Improving Query Tom Lane
• 16:14   Re: Optimizing PostgreSQL for Windows Dave Dutcher
• 16:41   Re: Improving Query Ketema Harris
• 18:17   tables with 300+ partitions Pablo Alcaraz
• 18:57   Re: tables with 300+ partitions Heikki Linnakangas
• 19:21   Re: Optimizing PostgreSQL for Windows Guillaume Lelarge
• 21:00   Re: tables with 300+ partitions Steven Flatt
• 21:08   Two fast queries get slow when combined cluster
• 21:53   Re: Two fast queries get slow when combined Heikki Linnakangas

31 October 2007

• 04:05   Re: Two fast queries get slow when combined Tom Lane
• 08:44   Re: Optimizing PostgreSQL for Windows Christian Rengstl
• 09:38   Re: Two fast queries get slow when combined cluster
• 10:08   Re: Two fast queries get slow when combined cluster
• 14:30   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 16:14   Re: tables with 300+ partitions Pablo Alcaraz
• 16:42   hardware and For PostgreSQL Ketema Harris
• 18:23   Re: tables with 300+ partitions Steven Flatt
• 18:25   Hardware for PostgreSQL Ketema
• 18:43   Re: hardware and For PostgreSQL Ben
• 19:05   Re: tables with 300+ partitions Scott Marlowe
• 19:40   Re: hardware and For PostgreSQL Scott Marlowe
• 19:44   Re: tables with 300+ partitions Tomáš Vondra
• 20:51   Re: hardware and For PostgreSQL Joe Uhl
• 21:12   Re: Hardware for PostgreSQL Magnus Hagander
• 21:15   Re: Hardware for PostgreSQL Arjen van der Meijden
• 21:53   Re: tables with 300+ partitions Pablo Alcaraz
• 22:19   Re: Hardware for PostgreSQL Tomas Vondra
• 22:24   Re: hardware and For PostgreSQL Ron St-Pierre
• 22:33   [Fwd: Re: Outer joins and Seq scans] Sami Dalouche
• 22:50   Re: Hardware for PostgreSQL Kevin Grittner
• 22:57   Re: [Fwd: Re: Outer joins and Seq scans] Tom Lane
• 23:20   Re: hardware and For PostgreSQL Joshua D. Drake
• 23:31   Re: hardware and For PostgreSQL Paul Lambert