Mailing lists [pgsql-performance]

1 July 2015

• 01:56   Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus

2 July 2015

• 02:07   New server: SSD/RAID recommendations? Craig James
• 02:56   Re: New server: SSD/RAID recommendations? Andreas Joseph Krogh
• 02:57   Re: New server: SSD/RAID recommendations? Scott Marlowe
• 17:01   Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske)
• 17:26   Re: New server: SSD/RAID recommendations? Merlin Moncure
• 18:41   Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v
• 20:20   Re: New server: SSD/RAID recommendations? Craig James
• 20:22   Re: New server: SSD/RAID recommendations? Craig James
• 20:44   Re: New server: SSD/RAID recommendations? Craig James
• 21:00   Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske)
• 22:31   Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus
• 22:33   Re: Sudden connection and load average spikes with postgresql 9.3 Josh Berkus

3 July 2015

• 00:13   Re: Sudden connection and load average spikes with postgresql 9.3 Kevin Grittner
• 02:04   Re: Sudden connection and load average spikes with postgresql 9.3 Scott Marlowe
• 17:48   Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 19:15   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Marc Mamin

5 July 2015

• 14:11   9.5alpha1 vs 9.4 Mkrtchyan, Tigran
• 14:46   Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran
• 15:54   Re: 9.5alpha1 vs 9.4 Andres Freund
• 17:34   Re: 9.5alpha1 vs 9.4 Tom Lane
• 17:47   Re: pgbouncer issue Greg Sabino Mullane
• 20:16   Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran

6 July 2015

• 19:40   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure
• 19:45   Re: 9.5alpha1 vs 9.4 Josh Berkus
• 19:56   Re: New server: SSD/RAID recommendations? Steve Crawford
• 20:20   Re: New server: SSD/RAID recommendations? Joshua D. Drake

7 July 2015

• 00:14   Re: 9.5alpha1 vs 9.4 Mkrtchyan, Tigran
• 13:22   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 13:28   Re: New server: SSD/RAID recommendations? Mkrtchyan, Tigran
• 13:38   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 13:57   Re: New server: SSD/RAID recommendations? Mkrtchyan, Tigran
• 14:28   Re: New server: SSD/RAID recommendations? Karl Denninger
• 14:29   Re: Sudden connection and load average spikes with postgresql 9.3 eudald_v
• 14:52   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 15:04   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 15:39   Re: New server: SSD/RAID recommendations? Karl Denninger
• 16:09   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 16:13   Re: New server: SSD/RAID recommendations? Merlin Moncure
• 16:25   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 17:16   Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske)
• 17:59   Re: New server: SSD/RAID recommendations? Heikki Linnakangas
• 18:40   wildcard text filter switched to boolean column, performance is way worse Mike Broers
• 18:53   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 18:58   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 19:02   Re: wildcard text filter switched to boolean column, performance is way worse Tom Lane
• 19:10   Re: wildcard text filter switched to boolean column, performance is way worse Mike Broers
• 19:28   Re: New server: SSD/RAID recommendations? Vitalii Tymchyshyn
• 19:28   Re: wildcard text filter switched to boolean column, performance is way worse Mike Broers
• 19:35   Re: New server: SSD/RAID recommendations? Merlin Moncure
• 19:46   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 19:56   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 19:56   Re: New server: SSD/RAID recommendations? Wei Shan
• 19:59   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 20:06   Re: New server: SSD/RAID recommendations? Karl Denninger
• 20:17   Re: Sudden connection and load average spikes with postgresql 9.3 Scott Marlowe
• 20:21   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 20:28   Re: New server: SSD/RAID recommendations? Michael Nolan
• 20:43   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 20:47   Re: New server: SSD/RAID recommendations? Scott Marlowe
• 20:58   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 21:01   Re: New server: SSD/RAID recommendations? Wes Vaske (wvaske)
• 21:23   Re: New server: SSD/RAID recommendations? Merlin Moncure
• 22:53   Re: New server: SSD/RAID recommendations? Heikki Linnakangas
• 23:00   Re: New server: SSD/RAID recommendations? Graeme B. Bell
• 23:05   Re: New server: SSD/RAID recommendations? Heikki Linnakangas
• 23:33   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 23:52   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure

8 July 2015

• 05:05   Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 06:06   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Craig James
• 08:31   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Joshua D. Drake
• 10:43   Re: wildcard text filter switched to boolean column, performance is way worse Marc Mamin
• 14:07   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 14:13   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 14:20   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Andres Freund
• 20:48   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Craig James
• 20:52   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Joshua D. Drake
• 21:09   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Craig James
• 21:47   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure
• 23:27   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Andres Freund

9 July 2015

• 01:38   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Craig James
• 01:45   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? andres@anarazel.de (Andres Freund)
• 06:39   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Tom Lane
• 11:59   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 12:00   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Andres Freund
• 12:44   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 13:30   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 13:33   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Andres Freund
• 15:20   pg_stat_all_indexes understand Nicolas Paris
• 15:58   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure
• 16:03   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure
• 16:22   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Thomas Kellerer
• 18:04   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 18:12   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 18:22   Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 18:42   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Merlin Moncure
• 19:00   Re: [BUGS] BUG #13493: pl/pgsql doesn't scale with cpus (PG9.3, 9.4) Graeme B. Bell
• 19:31   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? Graeme B. Bell
• 19:45   Re: pg_stat_all_indexes understand Jeff Janes
• 23:34   QUERY PLANNER - Indexe mono column VS composite Index Nicolas Paris
• 23:49   Re: QUERY PLANNER - Indexe mono column VS composite Index Guillaume Lelarge

10 July 2015

• 12:34   Re: QUERY PLANNER - Indexe mono column VS composite Index Nicolas Paris
• 19:20   Re: QUERY PLANNER - Indexe mono column VS composite Index Jeff Janes

12 July 2015

• 02:23   Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this? James Cloos

13 July 2015

• 23:54   Query planner not using indexes with JOIN query and OR clause Ben Hoyt

14 July 2015

• 00:01   Re: Query planner not using indexes with JOIN query and OR clause Merlin Moncure
• 03:08   Re: could not create shared memory segment: Invalid argument Ryan King - NOAA Affiliate
• 03:15   Re: [ADMIN] could not create shared memory segment: Invalid argument Scott Whitney
• 16:14   Re: Query planner not using indexes with JOIN query and OR clause Merlin Moncure
• 23:17   Re: Query planner not using indexes with JOIN query and OR clause Ben Hoyt

15 July 2015

• 19:16   Insert vs Update Robert DiFalco
• 20:10   Re: Insert vs Update David G. Johnston
• 20:15   Re: Insert vs Update Michael Nolan
• 20:33   Re: Insert vs Update David G. Johnston
• 20:56   Re: Insert vs Update Robert DiFalco
• 21:15   Re: Insert vs Update David G. Johnston
• 22:16   Re: Insert vs Update Robert DiFalco
• 22:32   Re: Insert vs Update David G. Johnston
• 22:49   Re: Insert vs Update Robert DiFalco
• 23:53   Re: Insert vs Update Michael Nolan

16 July 2015

• 00:14   Re: Insert vs Update David G. Johnston
• 08:13   Re: Insert vs Update Guillaume Lelarge

18 July 2015

• 13:03   Re: intel s3500 -- hot stuff Julien Rouhaud

19 July 2015

• 23:41   Re: Different plan for very similar queries Peter J. Holzer

21 July 2015

• 05:59   hyperthreadin low performance Jeison Bedoya Delgado
• 11:04   Re: hyperthreadin low performance David Rowley
• 12:08   Re: hyperthreadin low performance Mark Kirkwood

22 July 2015

• 15:50   How to find the culprit in server load spikes? Moreno Andreo
• 19:41   Re: How to find the culprit in server load spikes? Kevin Grittner
• 20:18   Re: How to find the culprit in server load spikes? Jeff Janes

23 July 2015

• 14:37   Re: hyperthreadin low performance domenico febbo
• 15:41   Re: hyperthreadin low performance (and some discussion about benchmarking) Graeme B. Bell
• 16:46   parallelisation provides postgres performance (script example + ppt slides) Graeme B. Bell
• 19:58   bitmap heap scan recheck for gin/fts with no lossy blocks Laurent Debacker
• 21:04   Re: bitmap heap scan recheck for gin/fts with no lossy blocks Jeff Janes

25 July 2015

• 00:41   Re: bitmap heap scan recheck for gin/fts with no lossy blocks Laurent Debacker
• 01:27   Re: bitmap heap scan recheck for gin/fts with no lossy blocks Jeff Janes
• 07:10   Re: hyperthreadin low performance Mark Kirkwood
• 17:50   Are many idle connections bad? Craig James
• 18:05   Re: Are many idle connections bad? Tom Lane
• 19:06   Re: Are many idle connections bad? Craig James

26 July 2015

• 03:43   Re: Are many idle connections bad? Jeff Janes

28 July 2015

• 10:52   Any ideas how can I speed up this query? Priyank Tiwari
• 11:19   Re: Any ideas how can I speed up this query? Graeme B. Bell
• 11:58   Re: Any ideas how can I speed up this query? 林士博
• 18:39   autofreeze/vacuuming - avoiding the random performance hit Graeme B. Bell
• 18:51   Re: autofreeze/vacuuming - avoiding the random performance hit Wei Shan
• 19:16   Re: autofreeze/vacuuming - avoiding the random performance hit Graeme B. Bell
• 23:29   incredible surprise news from intel/micron right now... Graeme B. Bell

30 July 2015

• 09:28   Re: Are many idle connections bad? Alex Hunsaker
• 10:52   Performance issue with NestedLoop query Ram N
• 23:24   Re: Performance issue with NestedLoop query Qingqing Zhou

31 July 2015

• 20:56   Re: Performance issue with NestedLoop query Ram N
• 21:06   Re: Performance issue with NestedLoop query Matheus de Oliveira
• 21:08   Re: Performance issue with NestedLoop query Matheus de Oliveira
• 21:37   Re: Performance issue with NestedLoop query Qingqing Zhou