Mailing lists [pgsql-performance]

1 December 2013

• 09:22   Speed up the query Hengky Liwandouw
• 10:12   Re: Speed up the query Andreas Kretschmer
• 11:32   Re: Speed up the query Hengky Liwandouw
• 11:35   Re: Speed up the query Andreas Kretschmer
• 12:08   Re: Speed up the query Hengky Liwandouw
• 14:27   Re: Speed up the query desmodemone
• 15:11   Re: Speed up the query Torsten Förtsch
• 15:25   Re: Speed up the query Hengky Liwandouw
• 15:27   Re: Speed up the query Andreas Kretschmer
• 15:29   Re: Speed up the query Andreas Kretschmer
• 17:11   Re: Speed up the query Hengky Liwandouw
• 19:02   Re: Speed up the query Kevin Grittner
• 19:14   Re: Speed up the query Hengky Lie
• 20:33   Re: Speed up the query Hengky Lie
• 20:41   Re: Speed up the query Hengky Lie

3 December 2013

• 02:17   Re: One query run twice in parallel results in huge performance decrease Jeff Janes
• 04:59   Re: One query run twice in parallel results in huge performance decrease Scott Marlowe
• 16:49   Parallel Select query performance and shared buffers Metin Doslu
• 16:53   Re: Parallel Select query performance and shared buffers Alvaro Herrera
• 18:56   Re: Parallel Select query performance and shared buffers Claudio Freire
• 19:25   Re: Parallel Select query performance and shared buffers Metin Doslu
• 19:32   Re: Parallel Select query performance and shared buffers Claudio Freire
• 23:18   Re: One query run twice in parallel results in huge performance decrease Jan Michel

4 December 2013

• 15:19   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 16:19   Re: Parallel Select query performance and shared buffers Metin Doslu
• 19:27   Re: [HACKERS] Parallel Select query performance and shared buffers Claudio Freire
• 19:33   Re: [HACKERS] Parallel Select query performance and shared buffers Andres Freund
• 19:35   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 19:43   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 19:54   Re: [HACKERS] Parallel Select query performance and shared buffers Andres Freund
• 21:00   Re: [HACKERS] Parallel Select query performance and shared buffers Claudio Freire
• 21:03   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 21:04   Re: [HACKERS] Parallel Select query performance and shared buffers Andres Freund
• 21:10   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 21:20   Re: Parallel Select query performance and shared buffers Metin Doslu
• 21:26   Re: [HACKERS] Parallel Select query performance and shared buffers Andres Freund
• 21:28   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu

5 December 2013

• 01:38   Parallel Select query performance and shared buffers Metin Doslu
• 07:16   Re: Parallel Select query performance and shared buffers Amit Kapila
• 12:15   Re: Parallel Select query performance and shared buffers Metin Doslu
• 12:18   Re: Parallel Select query performance and shared buffers Andres Freund
• 12:33   Re: Parallel Select query performance and shared buffers Metin Doslu
• 12:42   Re: Parallel Select query performance and shared buffers Andres Freund
• 13:42   One huge db vs many small dbs Max
• 17:09   Explain analyze time overhead salah jubeh
• 17:21   Re: Explain analyze time overhead vincent elschot
• 17:22   Re: Explain analyze time overhead Tom Lane
• 17:28   Re: One huge db vs many small dbs bricklen
• 17:45   Re: Explain analyze time overhead salah jubeh
• 18:02   WAL + SSD = slow inserts? Skarsol
• 18:06   Re: WAL + SSD = slow inserts? desmodemone
• 18:16   Re: WAL + SSD = slow inserts? Skarsol
• 18:36   Recommendations for partitioning? Dave Johansen
• 18:46   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 18:50   Re: WAL + SSD = slow inserts? Scott Marlowe
• 18:52   Re: [HACKERS] Parallel Select query performance and shared buffers Andres Freund
• 18:57   Re: [HACKERS] Parallel Select query performance and shared buffers Metin Doslu
• 18:57   Re: One huge db vs many small dbs Joe Conway
• 19:03   Re: Parallel Select query performance and shared buffers Metin Doslu
• 19:13   Re: WAL + SSD = slow inserts? Skarsol
• 19:14   Re: One huge db vs many small dbs David Johnston
• 20:57   Re: WAL + SSD = slow inserts? Jeff Janes
• 21:08   Re: WAL + SSD = slow inserts? Scott Marlowe
• 21:13   Re: Parallel Select query performance and shared buffers Claudio Freire
• 22:19   Re: WAL + SSD = slow inserts? bricklen
• 23:29   Re: Explain analyze time overhead Kevin Grittner

6 December 2013

• 00:39   Re: One huge db vs many small dbs Nicholson, Brad (Toronto, ON, CA)
• 00:53   Re: One huge db vs many small dbs Joshua D. Drake
• 01:01   Re: WAL + SSD = slow inserts? Mark Kirkwood
• 03:01   Re: One huge db vs many small dbs Josh Berkus
• 08:55   Re: WAL + SSD = slow inserts? Skarsol
• 08:59   Re: One huge db vs many small dbs Pavel Stehule
• 09:03   Re: WAL + SSD = slow inserts? Rosser Schwarz
• 17:31   Similarity search with the tsearch2 extension Janek Sendrowski
• 17:54   Re: Similarity search with the tsearch2 extension Kevin Grittner
• 20:37   postgres performance chidamparam muthusamy
• 21:16   Re: postgres performance Alan Hodgson
• 21:37   Re: postgres performance Richard Huxton

7 December 2013

• 02:31   Re: Reseting statistics counters Tomas Vondra
• 02:59   Re: WAL + SSD = slow inserts? Tomas Vondra
• 03:13   Re: postgres performance Tomas Vondra
• 13:30   Re: postgres performance chidamparam muthusamy
• 15:43   Re: One huge db vs many small dbs Oliver Seemann
• 15:55   Re: postgres performance desmodemone
• 20:09   Re: Recommendations for partitioning? desmodemone
• 23:29   Re: Recommendations for partitioning? Jeff Janes
• 23:37   Re: Recommendations for partitioning? Scott Marlowe

10 December 2013

• 12:46   Hash join mspasic@openlinksw.com
• 20:28   select count(distinct ...) is slower than select distinct in about 5x jacket41142
• 21:16   Re: select count(distinct ...) is slower than select distinct in about 5x Kevin Grittner
• 21:19   Re: select count(distinct ...) is slower than select distinct in about 5x Jeff Janes
• 23:03   Re: Parallel Select query performance and shared buffers Merlin Moncure
• 23:06   Re: Parallel Select query performance and shared buffers Claudio Freire
• 23:20   Re: Parallel Select query performance and shared buffers Merlin Moncure
• 23:40   Re: Explain analyze time overhead Bruce Momjian

11 December 2013

• 00:54   Re: Explain analyze time overhead salah jubeh
• 00:59   Re: Explain analyze time overhead Bruce Momjian
• 04:23   Re: select count(distinct ...) is slower than select distinct in about 5x jacket41142
• 04:57   Re: select count(distinct ...) is slower than select distinct in about 5x jacket41142
• 05:25   Re: select count(distinct ...) is slower than select distinct in about 5x Jeff Janes
• 07:28   select count(distinct ...) is slower than select distinct in about 5x jacket41142
• 07:28   Debugging shared memory issues on CentOS Mack Talcott
• 07:28   Problem with slow query with WHERE conditions with OR clause on primary keys Krzysztof Olszewski
• 07:54   Re: Debugging shared memory issues on CentOS Tom Lane
• 10:18   Re: Problem with slow query with WHERE conditions with OR clause on primary keys David Johnston
• 18:41   When is a query slow? Michael Sacket

12 December 2013

• 01:29   ORDER BY using index, tsearch2 Janek Sendrowski
• 01:31   ORDER BY using index, tsearch2 [READ THIS!] Janek Sendrowski
• 02:33   Re: ORDER BY using index, tsearch2 [READ THIS!] Tom Lane
• 02:38   Re: ORDER BY using index, tsearch2 Craig James
• 02:56   Re: ORDER BY using index, tsearch2 Tom Lane
• 04:00   Re: ORDER BY using index, tsearch2 Janek Sendrowski
• 05:04   Re: Debugging shared memory issues on CentOS Mack Talcott
• 06:22   Re: select count(distinct ...) is slower than select distinct in about 5x jacket41142
• 06:40   Re: Debugging shared memory issues on CentOS Tom Lane
• 06:57   Re: ORDER BY using index, tsearch2 Tom Lane
• 16:16   Re: ORDER BY using index, tsearch2 Janek Sendrowski
• 17:57   Re: Debugging shared memory issues on CentOS Merlin Moncure
• 18:17   Re: Debugging shared memory issues on CentOS Tom Lane
• 23:10   Slow query due to slow I/O Bryce Covert
• 23:16   Re: Slow query due to slow I/O Claudio Freire
• 23:21   Re: Slow query due to slow I/O Bryce Covert
• 23:48   Re: Slow query due to slow I/O Claudio Freire

13 December 2013

• 00:16   Re: Slow query due to slow I/O Bryce Covert
• 00:25   Re: Slow query due to slow I/O Bryce Covert
• 00:36   Re: Slow query due to slow I/O Claudio Freire
• 00:49   Re: Slow query due to slow I/O Bryce Covert
• 02:04   Re: Slow query due to slow I/O Bryce Covert
• 02:39   Re: Slow query due to slow I/O Claudio Freire
• 03:02   Re: Slow query due to slow I/O Jeff Janes
• 03:03   Re: Slow query due to slow I/O Bryce Covert

15 December 2013

• 19:20   Current query of the PL/pgsql procedure. Yuri Levinsky
• 21:05   Re: Current query of the PL/pgsql procedure. Craig James

16 December 2013

• 13:26   Re: Current query of the PL/pgsql procedure. hubert depesz lubaczewski
• 14:44   Re: Current query of the PL/pgsql procedure. Yuri Levinsky
• 15:48   Re: Current query of the PL/pgsql procedure. Matheus de Oliveira
• 16:29   Re: Current query of the PL/pgsql procedure. Andrew Dunstan

17 December 2013

• 00:53   Adding an additional join causes very different/slow query plan Joe Van Dyk
• 01:00   Re: Adding an additional join causes very different/slow query plan Joe Van Dyk
• 03:14   Re: Adding an additional join causes very different/slow query plan Tom Lane
• 03:37   Re: Adding an additional join causes very different/slow query plan Joe Van Dyk
• 17:01   Re: Adding an additional join causes very different/slow query plan Stephen Frost

18 December 2013

• 11:30   Re: Current query of the PL/pgsql procedure. Guillaume Lelarge
• 23:12   Re: Problem with slow query with WHERE conditions with OR clause on primary keys David Johnston

19 December 2013

• 04:32   Re: Problem with slow query with WHERE conditions with OR clause on primary keys Andreas Karlsson
• 16:06   query not using index Johann Spies
• 17:49   Re: query not using index Tom Lane
• 18:33   query plan not optimal Marc Cousin
• 19:41   Re: Debugging shared memory issues on CentOS Mack Talcott
• 19:41   slow query - will CLUSTER help? Sev Zaslavsky
• 19:41   slow loading of pages for SELECT query - will CLUSTER help? Sev Zaslavsky
• 19:43   Help with cursor query that is intermittently slow Drew Jetter
• 19:45   Optimizing a query Kai Sellgren
• 19:46   Re: Problem with slow query with WHERE conditions with OR clause on primary keys kolszew73@gmail.com
• 19:47   Regarding Hardware Tuning prashant Pandey
• 19:53   Re: Recommendations for partitioning? Dave Johansen
• 20:00   Unexpected pgbench result Dave Johansen
• 20:27   Re: Recommendations for partitioning? Scott Marlowe
• 20:30   Re: Re: Problem with slow query with WHERE conditions with OR clause on primary keys Pavel Stehule
• 20:44   Re: Unexpected pgbench result Shaun Thomas
• 20:54   Re: Optimizing a query Shaun Thomas
• 21:19   Re: slow query - will CLUSTER help? Shaun Thomas
• 21:33   Re: query plan not optimal Jeff Janes
• 22:00   Re: query plan not optimal Marc Cousin
• 23:14   Re: slow query - will CLUSTER help? Kevin Grittner
• 23:33   Re: slow query - will CLUSTER help? Jeff Janes
• 23:34   Re: slow query - will CLUSTER help? Sergey Konoplev
• 23:36   Re: query plan not optimal Kevin Grittner

20 December 2013

• 00:24   Re: slow query - will CLUSTER help? Sergey Konoplev
• 01:06   Re: Unexpected pgbench result Dave Johansen
• 02:40   Re: Regarding Hardware Tuning Steve Crawford
• 03:35   DATE_TRUNC() and GROUP BY? Dave Johansen
• 03:37   Re: Regarding Hardware Tuning Scott Marlowe
• 09:05   Re: query plan not optimal Marc Cousin
• 17:10   Re: Unexpected pgbench result Shaun Thomas
• 17:29   Re: Regarding Hardware Tuning Shaun Thomas
• 17:42   Re: slow query - will CLUSTER help? Shaun Thomas
• 18:02   Re: Unexpected pgbench result Dave Johansen
• 18:22   Re: Unexpected pgbench result Kevin Grittner
• 18:40   Re: Unexpected pgbench result Dave Johansen
• 18:53   Re: Recommendations for partitioning? Dave Johansen
• 19:07   Re: Recommendations for partitioning? bricklen
• 19:11   Re: slow query - will CLUSTER help? Shaun Thomas
• 19:12   Re: Recommendations for partitioning? Alvaro Herrera
• 19:18   Re: Recommendations for partitioning? Shaun Thomas
• 19:23   Re: Recommendations for partitioning? Dave Johansen
• 19:24   Re: Recommendations for partitioning? Dave Johansen

21 December 2013

• 00:23   Re: slow query - will CLUSTER help? Gavin Flower
• 08:46   Re: DATE_TRUNC() and GROUP BY? David Rowley

23 December 2013

• 09:32   Strange number of rows in plan cost Алексей Кузнецов
• 11:59   Re: query not using index Johann Spies
• 19:41   Re: slow query - will CLUSTER help? Shaun Thomas
• 23:16   Bytea(TOAST) vs large object facility(OID) kosalram Babu Chellappa

24 December 2013

• 03:32   Re: Optimizing a query Mark Kirkwood
• 10:55   Re: Bytea(TOAST) vs large object facility(OID) Albe Laurenz

26 December 2013

• 11:46   Re: How to completely delete iPhone all data before selling? shirleymi
• 22:49   Possible regression (slow query on 9.2/9.3 when compared to 9.1) Ronaldo Maia

27 December 2013

• 09:35   Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order. Michael Kolomeitsev
• 18:55   Does fsync on/off for wal AND Checkpoint? GR Vishwanath
• 19:27   Re: Does fsync on/off for wal AND Checkpoint? Andreas Karlsson

28 December 2013

• 05:31   Re: query not using index Mark Kirkwood
• 08:19   Are there some additional postgres tuning to improve performance in multi tenant system ankush upadhyay
• 12:54   Re: Are there some additional postgres tuning to improve performance in multi tenant system Mark Kirkwood
• 14:40   Re: Are there some additional postgres tuning to improve performance in multi tenant system ankush upadhyay
• 16:20   Re: Are there some additional postgres tuning to improve performance in multi tenant system Andrew Dunstan
• 16:46   Re: Are there some additional postgres tuning to improve performance in multi tenant system ankush upadhyay
• 16:54   Re: Are there some additional postgres tuning to improve performance in multi tenant system Andrew Dunstan

29 December 2013

• 00:03   Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order. Kevin Grittner
• 00:19   Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order. Gavin Flower
• 00:56   Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order. Tom Lane
• 03:52   Re: Pg makes nonoptimal choice between two multicolumn indexes with the same columns but in different order. Michael Kolomeitsev
• 21:51   query plan not optimal Jeff Janes
• 23:08   Re: Error install -pgmemcache Devrim GÜNDÜZ

30 December 2013

• 01:32   Re: Possible regression (slow query on 9.2/9.3 when compared to 9.1) Tom Lane
• 23:22   Re: Recommendations for partitioning? Sergey Konoplev

31 December 2013

• 00:29   Re: Recommendations for partitioning? Alvaro Herrera
• 20:56   Re: Performance bug in prepared statement binding in 9.2? Tom Lane