Mailing lists [pgsql-performance]

1 May 2013

• 12:43   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 17:05   Deterioration in performance when query executed in multi threads Anne Rosset
• 17:07   Re: In progress INSERT wrecks plans on table Tom Lane
• 17:12   Re: Deterioration in performance when query executed in multi threads ktm@rice.edu
• 18:50   Re: [BUGS] BUG #8130: Hashjoin still gives issues Stefan de Konink
• 19:08   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 19:27   Re: Deterioration in performance when query executed in multi threads ktm@rice.edu
• 20:07   Re: Deterioration in performance when query executed in multi threads Scott Marlowe
• 20:10   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 20:26   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 20:59   Re: [BUGS] BUG #8130: Hashjoin still gives issues Igor Neyman
• 23:07   Re: [BUGS] BUG #8130: Hashjoin still gives issues Jeff Davis

2 May 2013

• 02:35   100x slowdown for nearly identical tables Craig James
• 03:18   Re: 100x slowdown for nearly identical tables Tom Lane
• 03:45   Re: 100x slowdown for nearly identical tables Craig James
• 03:53   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 04:51   Re: 100x slowdown for nearly identical tables Tom Lane
• 15:27   Re: In progress INSERT wrecks plans on table Simon Riggs
• 15:41   Re: Query planner ignoring constraints on partitioned tables when joining Simon Riggs
• 15:48   Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Simon Riggs
• 18:00   Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Claudio Freire

3 May 2013

• 01:19   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 01:32   Re: In progress INSERT wrecks plans on table Thomas Kellerer
• 01:59   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 02:11   Hardware suggestions for maximum read performance Mike McCann
• 04:35   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 09:17   Re: Hardware suggestions for maximum read performance Arjen van der Meijden
• 13:39   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 15:41   Re: In progress INSERT wrecks plans on table Simon Riggs
• 15:49   Re: Hardware suggestions for maximum read performance Julien Cigar
• 23:52   Re: Deterioration in performance when query executed in multi threads Anne Rosset

4 May 2013

• 15:49   Re: In progress INSERT wrecks plans on table Simon Riggs

6 May 2013

• 04:52   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 09:53   Re: Hardware suggestions for maximum read performance Yuri Levinsky
• 11:14   Re: In progress INSERT wrecks plans on table Simon Riggs
• 17:06   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 19:11   Re: Deterioration in performance when query executed in multi threads Merlin Moncure
• 19:33   RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Christoph Berg
• 19:33   Deterioration in performance when query executed in multi threads Anne Rosset
• 19:33   Re: In progress INSERT wrecks plans on table Gavin Flower
• 19:38   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane
• 20:01   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 20:10   Re: Deterioration in performance when query executed in multi threads Thomas Kellerer
• 20:12   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 20:25   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 23:19   Re: In progress INSERT wrecks plans on table Matt Clarkson

7 May 2013

• 00:47   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 00:52   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 01:11   Re: Deterioration in performance when query executed in multi threads Gavin Flower
• 03:24   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 05:04   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 09:10   Re: In progress INSERT wrecks plans on table Simon Riggs
• 09:32   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 10:19   Re: In progress INSERT wrecks plans on table Matt Clarkson
• 10:33   Re: In progress INSERT wrecks plans on table Simon Riggs
• 11:18   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 20:53   Re: Deterioration in performance when query executed in multi threads Anne Rosset

8 May 2013

• 02:22   Re: Hardware suggestions for maximum read performance Jeff Janes

9 May 2013

• 19:09   Re: Setting vacuum_freeze_min_age really low Robert Haas
• 20:18   Re: Setting vacuum_freeze_min_age really low Andres Freund
• 20:22   Re: Setting vacuum_freeze_min_age really low Andres Freund

10 May 2013

• 13:48   Re: In progress INSERT wrecks plans on table Vitalii Tymchyshyn
• 15:51   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 16:31   Re: In progress INSERT wrecks plans on table Tom Lane
• 22:57   Re: PostgreSQL planner Robert Haas

11 May 2013

• 02:12   Re: PostgreSQL planner Misa Simic
• 07:59   Re: In progress INSERT wrecks plans on table Mark Kirkwood

12 May 2013

• 02:28   Re: Setting vacuum_freeze_min_age really low Josh Berkus
• 15:50   Re: Setting vacuum_freeze_min_age really low Andres Freund

13 May 2013

• 16:05   Lock and pg_stat Desbiens, Eric
• 18:01   statistics target for columns in unique constraint? ach
• 20:21   Re: Setting vacuum_freeze_min_age really low Robert Haas
• 20:43   Re: Setting vacuum_freeze_min_age really low Andres Freund
• 22:58   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 23:08   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Mark Felder
• 23:14   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane
• 23:29   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 23:33   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane

14 May 2013

• 01:10   Re: statistics target for columns in unique constraint? Marti Raudsepp
• 01:36   Re: Hardware suggestions for maximum read performance Mike McCann
• 01:42   Re: statistics target for columns in unique constraint? Mark Kirkwood
• 02:24   Re: Hardware suggestions for maximum read performance Jeff Janes
• 02:58   Re: Hardware suggestions for maximum read performance Mike McCann
• 04:10   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 12:23   Predicate information in EXPLAIN Command Sameer Thakur
• 12:30   Re: Predicate information in EXPLAIN Command Heikki Linnakangas
• 15:13   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 15:45   Re: Lock and pg_stat Robert Haas

15 May 2013

• 09:48   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Christoph Berg
• 09:52   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Christoph Berg
• 16:52   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 ktm@rice.edu
• 18:31   Thinking About Correlated Columns (again) Shaun Thomas
• 18:52   Re: Thinking About Correlated Columns (again) Heikki Linnakangas
• 19:23   Re: Thinking About Correlated Columns (again) Craig James
• 19:27   Re: Thinking About Correlated Columns (again) Shaun Thomas
• 19:40   Re: Thinking About Correlated Columns (again) Andrew Dunstan
• 20:31   Re: Thinking About Correlated Columns (again) Nikolas Everett
• 21:30   Re: Effect of the WindowAgg on the Nested Loop Robert Haas
• 22:22   Re: Thinking About Correlated Columns (again) eggyknap
• 23:15   Re: Thinking About Correlated Columns (again) Gavin Flower
• 23:20   Re: Effect of the WindowAgg on the Nested Loop Victor Yegorov
• 23:22   Re: Thinking About Correlated Columns (again) Gavin Flower
• 23:35   Re: Thinking About Correlated Columns (again) Thomas Kellerer
• 23:54   Re: Thinking About Correlated Columns (again) Craig James

16 May 2013

• 11:47   Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
• 15:47   Re: Thinking About Correlated Columns (again) Shaun Thomas
• 17:46   Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 20:32   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 21:34   Re: Reliability with RAID 10 SSD and Streaming Replication Jeff Janes
• 21:55   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure

17 May 2013

• 01:40   Re: Reliability with RAID 10 SSD and Streaming Replication Jeff Janes
• 02:52   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 03:07   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 03:22   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 04:35   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 10:10   Re: Reliability with RAID 10 SSD and Streaming Replication David Rees
• 14:26   Deleting Rows From Large Tables Rob Emery
• 16:17   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 16:19   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 17:26   Re: Deleting Rows From Large Tables Sékine Coulibaly

18 May 2013

• 10:15   Re: Deleting Rows From Large Tables Vitalii Tymchyshyn
• 18:36   Re: statistics target for columns in unique constraint? ach
• 22:50    Stefan Keller
• 22:54   Slow CTE Query Stefan Keller

19 May 2013

• 00:44   Re: Slow CTE Query Sergey Konoplev
• 07:40   Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks jonranes
• 23:36   Re: Deleting Rows From Large Tables Jeff Janes

20 May 2013

• 00:14   Re: Deleting Rows From Large Tables Greg Spiegelberg
• 01:15   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 01:34   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 05:42   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 05:44   Re: Hardware suggestions for maximum read performance Greg Smith
• 05:55   Re: Deleting Rows From Large Tables Greg Smith
• 06:01   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 06:10   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 06:57   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 17:12   Re: statistics target for columns in unique constraint? Kevin Grittner
• 23:58   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra

21 May 2013

• 01:32   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 14:56   pg_statsinfo : error could not connect to repository Sameer Thakur
• 16:19   performance database for backup/restore Jeison Bedoya
• 16:28   Re: performance database for backup/restore Evgeny Shishkin
• 18:11   Re: performance database for backup/restore Steve Crawford
• 18:23   Re: Cost of opening and closing an empty transaction Ross Reedstrom
• 18:46   Re: performance database for backup/restore ktm@rice.edu
• 19:11   Re: performance database for backup/restore Jeff Janes
• 19:43   Re: pg_statsinfo : error could not connect to repository Kasahara Tatsuhito
• 23:04   Re: performance database for backup/restore Jeison Bedoya

22 May 2013

• 00:53   Very slow inner join query Unacceptable latency. 
• 01:00   Re: Very slow inner join query Unacceptable latency. Jaime Casanova
• 02:17   Advice on tuning slow query Samuel Stearns
• 02:33   Re: Advice on tuning slow query Sergey Konoplev
• 03:19   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 04:27   Re: pg_statsinfo : error could not connect to repository Amit Langote
• 08:57   Re: Very slow inner join query Unacceptable latency. Amit Kapila
• 16:30   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 17:18   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 17:37   Advice on optimizing select/index Niels Kristian Schjødt
• 17:41   Re: Very slow inner join query Unacceptable latency. 
• 18:05   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 18:33   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 19:58   Re: Reliability with RAID 10 SSD and Streaming Replication Shaun Thomas
• 20:33   Re: Reliability with RAID 10 SSD and Streaming Replication David Boreham
• 21:06   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 21:28   Re: Reliability with RAID 10 SSD and Streaming Replication Shaun Thomas
• 21:45   Re: Reliability with RAID 10 SSD and Streaming Replication Shaun Thomas
• 22:07   Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake
• 22:30   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 22:51   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 23:01   Re: Reliability with RAID 10 SSD and Streaming Replication Shaun Thomas
• 23:07   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 23:57   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure

23 May 2013

• 00:49   Re: Reliability with RAID 10 SSD and Streaming Replication CSS
• 01:42   Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake
• 02:37   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 03:17   Re: Very slow inner join query Unacceptable latency. Jeff Janes
• 04:02   Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake
• 04:32   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 04:41   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 04:53   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 05:04   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 05:17   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 05:22   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 05:26   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 05:44   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 05:52   Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake
• 09:15   Re: Very slow inner join query Unacceptable latency. Amit Kapila
• 09:57   Re: Reliability with RAID 10 SSD and Streaming Replication Andrea Suisani
• 14:39   pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance Sachin D. Bhosale-Kotwal
• 16:47   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 16:55   Re: Reliability with RAID 10 SSD and Streaming Replication Andrea Suisani
• 20:20   Performance of complicated query Jonathan Morra
• 20:21   Re: Very slow inner join query Unacceptable latency. 
• 20:47   Re: Performance of complicated query Steve Crawford
• 20:57   Re: Performance of complicated query Jonathan Morra
• 21:07   Re: Setting vacuum_freeze_min_age really low Josh Berkus
• 22:23   Re: Performance of complicated query Vladimir Sitnikov
• 22:44   Re: Performance of complicated query Jonathan Morra
• 23:01   Re: Performance of complicated query Steve Crawford

24 May 2013

• 01:01   Re: Performance of complicated query Jonathan Morra
• 02:22   Re: Performance of complicated query james
• 02:35   Re: Very slow inner join query Unacceptable latency. Jaime Casanova
• 03:21   Re: Performance of complicated query Jonathan Morra
• 08:17   Re: Very slow inner join query Unacceptable latency. Amit Kapila
• 09:16   Re: [GENERAL] Very slow inner join query Unacceptable latency. Scott Marlowe
• 15:12   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 15:21   Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance Greg Smith
• 16:22   Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance sachin kotwal

25 May 2013

• 00:44   Re: [GENERAL] Very slow inner join query Unacceptable latency. 
• 01:03   Re: [GENERAL] Very slow inner join query Unacceptable latency. Scott Marlowe
• 16:46   Reporting query failing aup20

26 May 2013

• 00:00   Re: Reporting query failing Tomas Vondra
• 15:34   Re: Advice on optimizing select/index Robert Klemme

27 May 2013

• 17:03   Slow SELECT by primary key? Postgres 9.1.2 John Mudd
• 17:21   Re: Slow SELECT by primary key? Postgres 9.1.2 Evgeny Shishkin
• 17:36   Re: Slow SELECT by primary key? Postgres 9.1.2 John Mudd
• 17:59   Re: Slow SELECT by primary key? Postgres 9.1.2 Evgeny Shishkin

28 May 2013

• 01:18   Re: Slow SELECT by primary key? Postgres 9.1.2 John Mudd
• 09:49   Re: Slow SELECT by primary key? Postgres 9.1.2 Evgeniy Shishkin
• 11:10   Re: Slow SELECT by primary key? Postgres 9.1.2 Roman Konoval
• 15:40   Re: Slow SELECT by primary key? Postgres 9.1.2 Matheus de Oliveira
• 17:43   Re: Performance of complicated query Jonathan Morra
• 19:04   Re: Performance of complicated query Steve Crawford

29 May 2013

• 15:24   Best practice when reindexing in production Niels Kristian Schjødt
• 15:26   Re: Best practice when reindexing in production Magnus Hagander
• 15:31   Re: Best practice when reindexing in production Armand du Plessis
• 15:38   Re: Best practice when reindexing in production Niels Kristian Schjødt
• 15:42   Re: Best practice when reindexing in production Niels Kristian Schjødt
• 16:08   Re: Best practice when reindexing in production Magnus Hagander
• 16:12   Re: Best practice when reindexing in production Matheus de Oliveira
• 16:56   Re: Best practice when reindexing in production Igor Neyman
• 17:19   Re: Best practice when reindexing in production Matheus de Oliveira
• 17:44   Re: [GENERAL] Very slow inner join query Unacceptable latency. 
• 19:35   Re: Best practice when reindexing in production Igor Neyman
• 20:13   Re: Best practice when reindexing in production Jesper Krogh
• 20:25   Re: Best practice when reindexing in production Daniele Varrazzo
• 20:47   Re: Best practice when reindexing in production Alan Hodgson
• 22:22   Re: Best practice when reindexing in production Daniele Varrazzo

30 May 2013

• 03:14   Performance bug in prepared statement binding in 9.2? Josh Berkus
• 03:59   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 15:09   Check Pointer itishree sukla
• 15:20   Re: Check Pointer Greg Smith
• 15:20   Re: Check Pointer Dinesh Kumar
• 15:26   Re: Check Pointer Heikki Linnakangas
• 15:45   Re: Check Pointer itishree sukla
• 16:56   Re: Performance bug in prepared statement binding in 9.2? Amit Kapila
• 18:13   Re: Slow SELECT by primary key? Postgres 9.1.2 Merlin Moncure
• 18:22   Re: Slow SELECT by primary key? Postgres 9.1.2 Igor Neyman
• 18:24   Re: Slow SELECT by primary key? Postgres 9.1.2 John Mudd
• 18:59   Re: Slow SELECT by primary key? Postgres 9.1.2 Merlin Moncure
• 21:06   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 23:18   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus

31 May 2013

• 10:40   Re: Performance bug in prepared statement binding in 9.2? Amit Kapila
• 19:33   Evaluating query performance with caching in PostgreSQL 9.1.6 
• 19:58   Re: Evaluating query performance with caching in PostgreSQL 9.1.6 Marti Raudsepp
• 21:54   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus