Архив рассылок [pgsql-performance]

1 мая 2013 г.

• 09:43   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 14:05   Deterioration in performance when query executed in multi threads Anne Rosset
• 14:07   Re: In progress INSERT wrecks plans on table Tom Lane
• 14:12   Re: Deterioration in performance when query executed in multi threads ktm@rice.edu
• 15:50   Re: [BUGS] BUG #8130: Hashjoin still gives issues Stefan de Konink
• 16:08   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 16:27   Re: Deterioration in performance when query executed in multi threads ktm@rice.edu
• 17:07   Re: Deterioration in performance when query executed in multi threads Scott Marlowe
• 17:10   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 17:26   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 17:59   Re: [BUGS] BUG #8130: Hashjoin still gives issues Igor Neyman
• 20:07   Re: [BUGS] BUG #8130: Hashjoin still gives issues Jeff Davis
• 23:35   100x slowdown for nearly identical tables Craig James

2 мая 2013 г.

• 00:18   Re: 100x slowdown for nearly identical tables Tom Lane
• 00:45   Re: 100x slowdown for nearly identical tables Craig James
• 00:53   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 01:51   Re: 100x slowdown for nearly identical tables Tom Lane
• 12:27   Re: In progress INSERT wrecks plans on table Simon Riggs
• 12:41   Re: Query planner ignoring constraints on partitioned tables when joining Simon Riggs
• 12:48   Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Simon Riggs
• 15:00   Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Claudio Freire
• 22:19   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 22:32   Re: In progress INSERT wrecks plans on table Thomas Kellerer
• 22:59   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 23:11   Hardware suggestions for maximum read performance Mike McCann

3 мая 2013 г.

• 01:35   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 06:17   Re: Hardware suggestions for maximum read performance Arjen van der Meijden
• 10:39   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 12:41   Re: In progress INSERT wrecks plans on table Simon Riggs
• 12:49   Re: Hardware suggestions for maximum read performance Julien Cigar
• 20:52   Re: Deterioration in performance when query executed in multi threads Anne Rosset

4 мая 2013 г.

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

6 мая 2013 г.

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

7 мая 2013 г.

• 00:24   Re: In progress INSERT wrecks plans on table mark.kirkwood@catalyst.net.nz
• 02:04   Re: Deterioration in performance when query executed in multi threads Igor Neyman
• 06:10   Re: In progress INSERT wrecks plans on table Simon Riggs
• 06:32   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 07:19   Re: In progress INSERT wrecks plans on table Matt Clarkson
• 07:33   Re: In progress INSERT wrecks plans on table Simon Riggs
• 08:18   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 17:53   Re: Deterioration in performance when query executed in multi threads Anne Rosset
• 23:22   Re: Hardware suggestions for maximum read performance Jeff Janes

9 мая 2013 г.

• 16:09   Re: Setting vacuum_freeze_min_age really low Robert Haas
• 17:18   Re: Setting vacuum_freeze_min_age really low Andres Freund
• 17:22   Re: Setting vacuum_freeze_min_age really low Andres Freund

10 мая 2013 г.

• 10:48   Re: In progress INSERT wrecks plans on table Vitalii Tymchyshyn
• 12:51   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 13:31   Re: In progress INSERT wrecks plans on table Tom Lane
• 19:57   Re: PostgreSQL planner Robert Haas
• 23:12   Re: PostgreSQL planner Misa Simic

11 мая 2013 г.

• 04:59   Re: In progress INSERT wrecks plans on table Mark Kirkwood
• 23:28   Re: Setting vacuum_freeze_min_age really low Josh Berkus

12 мая 2013 г.

• 12:50   Re: Setting vacuum_freeze_min_age really low Andres Freund

13 мая 2013 г.

• 13:05   Lock and pg_stat Desbiens, Eric
• 15:01   statistics target for columns in unique constraint? ach
• 17:21   Re: Setting vacuum_freeze_min_age really low Robert Haas
• 17:43   Re: Setting vacuum_freeze_min_age really low Andres Freund
• 19:58   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 20:08   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Mark Felder
• 20:14   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane
• 20:29   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 20:33   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane
• 22:10   Re: statistics target for columns in unique constraint? Marti Raudsepp
• 22:36   Re: Hardware suggestions for maximum read performance Mike McCann
• 22:42   Re: statistics target for columns in unique constraint? Mark Kirkwood
• 23:24   Re: Hardware suggestions for maximum read performance Jeff Janes
• 23:58   Re: Hardware suggestions for maximum read performance Mike McCann

14 мая 2013 г.

• 01:10   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 09:23   Predicate information in EXPLAIN Command Sameer Thakur
• 09:30   Re: Predicate information in EXPLAIN Command Heikki Linnakangas
• 12:13   Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas
• 12:45   Re: Lock and pg_stat Robert Haas

15 мая 2013 г.

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

16 мая 2013 г.

• 08:47   Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
• 12:47   Re: Thinking About Correlated Columns (again) Shaun Thomas
• 14:46   Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 17:32   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 18:34   Re: Reliability with RAID 10 SSD and Streaming Replication Jeff Janes
• 18:55   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 22:40   Re: Reliability with RAID 10 SSD and Streaming Replication Jeff Janes
• 23:52   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang

17 мая 2013 г.

• 00:07   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 00:22   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 01:35   Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood
• 07:10   Re: Reliability with RAID 10 SSD and Streaming Replication David Rees
• 11:26   Deleting Rows From Large Tables Rob Emery
• 13:17   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 13:19   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure
• 14:26   Re: Deleting Rows From Large Tables Sékine Coulibaly

18 мая 2013 г.

• 07:15   Re: Deleting Rows From Large Tables Vitalii Tymchyshyn
• 15:36   Re: statistics target for columns in unique constraint? ach
• 19:50    Stefan Keller
• 19:54   Slow CTE Query Stefan Keller
• 21:44   Re: Slow CTE Query Sergey Konoplev

19 мая 2013 г.

• 04:40   Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks jonranes
• 20:36   Re: Deleting Rows From Large Tables Jeff Janes
• 21:14   Re: Deleting Rows From Large Tables Greg Spiegelberg
• 22:15   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 22:34   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra

20 мая 2013 г.

• 02:42   Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang
• 02:44   Re: Hardware suggestions for maximum read performance Greg Smith
• 02:55   Re: Deleting Rows From Large Tables Greg Smith
• 03:01   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 03:10   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 03:57   Re: Hardware suggestions for maximum read performance Scott Marlowe
• 14:12   Re: statistics target for columns in unique constraint? Kevin Grittner
• 20:58   Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra
• 22:32   Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure

21 мая 2013 г.

• 11:56   pg_statsinfo : error could not connect to repository Sameer Thakur
• 13:19   performance database for backup/restore Jeison Bedoya
• 13:28   Re: performance database for backup/restore Evgeny Shishkin
• 15:11   Re: performance database for backup/restore Steve Crawford
• 15:23   Re: Cost of opening and closing an empty transaction Ross Reedstrom
• 15:46   Re: performance database for backup/restore ktm@rice.edu
• 16:11   Re: performance database for backup/restore Jeff Janes
• 16:43   Re: pg_statsinfo : error could not connect to repository Kasahara Tatsuhito
• 20:04   Re: performance database for backup/restore Jeison Bedoya
• 21:53   Very slow inner join query Unacceptable latency. 
• 22:00   Re: Very slow inner join query Unacceptable latency. Jaime Casanova
• 23:17   Advice on tuning slow query Samuel Stearns
• 23:33   Re: Advice on tuning slow query Sergey Konoplev

22 мая 2013 г.

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

23 мая 2013 г.

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

24 мая 2013 г.

• 00:21   Re: Performance of complicated query Jonathan Morra
• 05:17   Re: Very slow inner join query Unacceptable latency. Amit Kapila
• 06:16   Re: [GENERAL] Very slow inner join query Unacceptable latency. Scott Marlowe
• 12:12   Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith
• 12:21   Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance Greg Smith
• 13:22   Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance sachin kotwal
• 21:44   Re: [GENERAL] Very slow inner join query Unacceptable latency. 
• 22:03   Re: [GENERAL] Very slow inner join query Unacceptable latency. Scott Marlowe

25 мая 2013 г.

• 13:46   Reporting query failing aup20
• 21:00   Re: Reporting query failing Tomas Vondra

26 мая 2013 г.

• 12:34   Re: Advice on optimizing select/index Robert Klemme

27 мая 2013 г.

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

28 мая 2013 г.

• 06:49   Re: Slow SELECT by primary key? Postgres 9.1.2 Evgeniy Shishkin
• 08:10   Re: Slow SELECT by primary key? Postgres 9.1.2 Roman Konoval
• 12:40   Re: Slow SELECT by primary key? Postgres 9.1.2 Matheus de Oliveira
• 14:43   Re: Performance of complicated query Jonathan Morra
• 16:04   Re: Performance of complicated query Steve Crawford

29 мая 2013 г.

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

30 мая 2013 г.

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

31 мая 2013 г.

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