pgsql-performance - May 2013

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

May 1, 2013

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

May 2, 2013

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

May 3, 2013

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

May 4, 2013

Thread Author Time
Re: In progress INSERT wrecks plans on table 📎 Simon Riggs 12:49

May 6, 2013

Thread Author Time
Re: In progress INSERT wrecks plans on table Mark Kirkwood 01:51
Re: Hardware suggestions for maximum read performance Yuri Levinsky 06:51
Re: In progress INSERT wrecks plans on table 📎 Simon Riggs 08:14
Re: Deterioration in performance when query executed in multi threads Igor Neyman 14:05
Re: Deterioration in performance when query executed in multi threads Merlin Moncure 16:11
Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Tom Lane 16:38
Re: Deterioration in performance when query executed in multi threads Anne Rosset 17:00
Re: Deterioration in performance when query executed in multi threads Thomas Kellerer 17:11
Re: Deterioration in performance when query executed in multi threads Igor Neyman 17:12
Re: Deterioration in performance when query executed in multi threads Igor Neyman 17:25
Re: In progress INSERT wrecks plans on table Matt Clarkson 20:18
Re: Deterioration in performance when query executed in multi threads Anne Rosset 21:46
Re: Deterioration in performance when query executed in multi threads Anne Rosset 21:51
Re: Deterioration in performance when query executed in multi threads Gavin Flower 22:11

May 7, 2013

Thread Author Time
Re: In progress INSERT wrecks plans on table mark.kirkwood 00:23
Re: Deterioration in performance when query executed in multi threads Igor Neyman 02:03
Re: In progress INSERT wrecks plans on table Simon Riggs 06:10
Re: In progress INSERT wrecks plans on table Mark Kirkwood 06:32
Re: In progress INSERT wrecks plans on table Matt Clarkson 07:19
Re: In progress INSERT wrecks plans on table Simon Riggs 07:33
Re: In progress INSERT wrecks plans on table Mark Kirkwood 08:17
Re: Deterioration in performance when query executed in multi threads Anne Rosset 17:53
Re: Hardware suggestions for maximum read performance Jeff Janes 23:21

May 9, 2013

Thread Author Time
Re: Setting vacuum_freeze_min_age really low Robert Haas 16:09
Re: Setting vacuum_freeze_min_age really low Andres Freund 17:18
Re: Setting vacuum_freeze_min_age really low Andres Freund 17:22

May 10, 2013

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

May 11, 2013

Thread Author Time
Re: In progress INSERT wrecks plans on table Mark Kirkwood 04:58
Re: Setting vacuum_freeze_min_age really low Josh Berkus 23:28

May 12, 2013

Thread Author Time
Re: Setting vacuum_freeze_min_age really low Andres Freund 12:50

May 13, 2013

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

May 14, 2013

Thread Author Time
Re: Hardware suggestions for maximum read performance Scott Marlowe 01:09
Re: Setting vacuum_freeze_min_age really low Josh Berkus 04:02
Predicate information in EXPLAIN Command Sameer Thakur 09:23
Re: Predicate information in EXPLAIN Command Heikki Linnakangas 09:29
Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1 Robert Haas 12:12
Re: Lock and pg_stat Robert Haas 12:44

May 15, 2013

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

May 16, 2013

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

May 17, 2013

Thread Author Time
Re: Reliability with RAID 10 SSD and Streaming Replication Tomas Vondra 00:06
Re: Reliability with RAID 10 SSD and Streaming Replication Cuong Hoang 00:21
Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood 01:34
Re: Reliability with RAID 10 SSD and Streaming Replication David Rees 06:34
Deleting Rows From Large Tables Rob Emery 11:26
Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure 13:17
Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure 13:19
Re: Deleting Rows From Large Tables Sékine Coulibaly 14:26

May 18, 2013

Thread Author Time
Re: Deleting Rows From Large Tables Vitalii Tymchyshyn 07:15
Re: statistics target for columns in unique constraint? ach 15:35
[No subject] Stefan Keller 19:50
Slow CTE Query Stefan Keller 19:54
Re: Slow CTE Query Sergey Konoplev 21:44

May 19, 2013

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

May 20, 2013

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

May 21, 2013

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

May 22, 2013

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

May 23, 2013

Thread Author Time
Re: Very slow inner join query Unacceptable latency. Jeff Janes 00:17
Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake 01:01
Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood 01:32
Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith 01:41
Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith 01:53
Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood 02:04
Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure 02:17
Re: Reliability with RAID 10 SSD and Streaming Replication Greg Smith 02:22
Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood 02:26
Re: Reliability with RAID 10 SSD and Streaming Replication Mark Kirkwood 02:44
Re: Reliability with RAID 10 SSD and Streaming Replication Joshua D. Drake 02:51
Re: Very slow inner join query Unacceptable latency. Amit Kapila 06:13
Re: Reliability with RAID 10 SSD and Streaming Replication Andrea Suisani 06:56
pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance 📎 Sachin D. Bhosale-Kotwal 11:39
Re: Reliability with RAID 10 SSD and Streaming Replication Merlin Moncure 13:47
Re: Reliability with RAID 10 SSD and Streaming Replication Andrea Suisani 13:55
Performance of complicated query Jonathan Morra 17:19
Re: [PERFORM] Very slow inner join query Unacceptable latency. 📎 fburgess 17:21
Re: Performance of complicated query Steve Crawford 17:47
Re: Performance of complicated query Jonathan Morra 17:57
Re: Performance of complicated query Vladimir Sitnikov 19:23
Re: Performance of complicated query Jonathan Morra 19:43
Re: Performance of complicated query Steve Crawford 20:01

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31