pgsql-performance - November 2011

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 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 27 28 29 30

Nov. 1, 2011

Thread Author Time
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim 03:03
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Marcus Engene 09:57
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! ktm@rice.edu 12:53
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra 13:13
Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! Tom Lane 13:43
procedure takes much more time than its query statement Sabin Coanda 14:01

Nov. 2, 2011

Thread Author Time
Re: procedure takes much more time than its query statement Dave Crooke 01:21
Re: procedure takes much more time than its query statement Craig Ringer 02:21
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim 07:12
Re: procedure takes much more time than its query statement Sabin Coanda 08:15
Intel 710 pgbench write latencies Yeb Havinga 13:05
Re: Intel 710 pgbench write latencies Kevin Grittner 14:06
Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Jay Levitt 14:22
Re: Intel 710 pgbench write latencies Merlin Moncure 14:26
Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! Tom Lane 14:26
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Tom Lane 14:38
Re: Intel 710 pgbench write latencies Yeb Havinga 15:04
Re: Intel 710 pgbench write latencies Magnus Hagander 15:06
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Robert Haas 15:13
Re: Intel 710 pgbench write latencies Yeb Havinga 15:16
Re: Intel 710 pgbench write latencies David Boreham 15:20
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Justin Pitts 16:41
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Andres Freund 17:13
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Claudio Freire 17:22
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Craig James 19:39
Re: Intel 710 pgbench write latencies Merlin Moncure 20:01
two table join just not fast enough. Brian Fehrle 20:12
Poor performance on a simple join CS DBA 20:21
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Igor Neyman 20:22
Re: Intel 710 pgbench write latencies Yeb Havinga 20:45
Re: Poor performance on a simple join Scott Marlowe 20:45
Re: Intel 710 pgbench write latencies Merlin Moncure 21:08
Re: Poor performance on a simple join CS DBA 21:53
Re: two table join just not fast enough. Tom Lane 23:53

Nov. 3, 2011

Thread Author Time
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Gavin Flower 00:17
Re: two table join just not fast enough. Brian Fehrle 00:33
Re: two table join just not fast enough. Mark Kirkwood 01:47
Re: Poor performance on a simple join Scott Marlowe 02:04
Re: Intel 710 pgbench write latencies Andy 05:56
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Craig Ringer 09:07
Re: Intel 710 pgbench write latencies Yeb Havinga 09:38
Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc? Igor Neyman 13:16
Re: Intel 710 pgbench write latencies Merlin Moncure 13:59
Re: Poor performance on a simple join Shaun Thomas 14:28
Re: Intel 710 pgbench write latencies Shaun Thomas 14:31
Re: Intel 710 pgbench write latencies Yeb Havinga 14:40
Re: function slower than the same code in an sql file Robert Haas 14:42
Re: SSL encryption makes bytea transfer slow Albe Laurenz 14:48
Re: SSL encryption makes bytea transfer slow ktm@rice.edu 15:01
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni 15:02
Re: function slower than the same code in an sql file Rodrigo Gonzalez 15:31
Re: Query running a lot faster with enable_nestloop=false Robert Haas 15:35
Re: function slower than the same code in an sql file Robert Haas 15:40
Optimization required for multiple insertions in PostgreSQL siva palanisamy 15:52
Re: Intel 710 pgbench write latencies Yeb Havinga 15:52
Re: Optimization required for multiple insertions in PostgreSQL Kevin Grittner 16:05
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra 16:08
Re: Optimization required for multiple insertions in PostgreSQL Tomas Vondra 16:18
Re: SSL encryption makes bytea transfer slow Marti Raudsepp 16:30
Predicates not getting pushed into SQL function? Jay Levitt 17:47
Blocking excessively in FOR UPDATE Claudio Freire 17:51
Re: Blocking excessively in FOR UPDATE Claudio Freire 17:55
Re: Optimization required for multiple insertions in PostgreSQL Kevin Grittner 18:32
Re: Predicates not getting pushed into SQL function? Tom Lane 18:41
Re: Blocking excessively in FOR UPDATE Tom Lane 18:45
Re: Predicates not getting pushed into SQL function? Jay Levitt 18:49
Re: Blocking excessively in FOR UPDATE Claudio Freire 19:29
Re: Blocking excessively in FOR UPDATE Claudio Freire 19:53
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni 20:07
Re: Predicates not getting pushed into SQL function? Tom Lane 20:35
Re: function slower than the same code in an sql file CS DBA 22:42
Re: Blocking excessively in FOR UPDATE Tom Lane 23:45

Nov. 4, 2011

Thread Author Time
Re: SSL encryption makes bytea transfer slow 📎 Albe Laurenz 08:43
Error while vacuuming Bhakti Ghatkar 12:14
Re: Error while vacuuming Guillaume Cottenceau 13:21
Re: Error while vacuuming Tom Lane 14:14
Re: Strange query plan Robert Haas 16:06
Re: Blocking excessively in FOR UPDATE Claudio Freire 16:07
Re: Blocking excessively in FOR UPDATE Robert Haas 16:10
Re: Strange query plan Sorbara, Giorgio (CIOK) 16:14
Re: Blocking excessively in FOR UPDATE Kevin Grittner 16:26
Re: Blocking excessively in FOR UPDATE Claudio Freire 16:48
Re: Blocking excessively in FOR UPDATE Kevin Grittner 17:07
Re: Blocking excessively in FOR UPDATE Claudio Freire 17:22
Re: Blocking excessively in FOR UPDATE Shaun Thomas 18:26
Re: Blocking excessively in FOR UPDATE Claudio Freire 18:45
Re: Strange query plan Robert Haas 18:49
Re: Blocking excessively in FOR UPDATE Robert Haas 18:54
Re: Blocking excessively in FOR UPDATE Shaun Thomas 19:00
Re: Blocking excessively in FOR UPDATE Claudio Freire 19:07
Re: SSL encryption makes bytea transfer slow Heikki Linnakangas 21:32
Re: Heavy contgnous load kzsolt 21:35

Nov. 7, 2011

Thread Author Time
PostgreSQL perform poorly on VMware ESXi Lucas Mocellin 10:36
Re: PostgreSQL perform poorly on VMware ESXi Tomas Vondra 10:54
Re: PostgreSQL perform poorly on VMware ESXi ktm@rice.edu 14:15
Re: PostgreSQL perform poorly on VMware ESXi Ivan Voras 15:21
Re: Predicates not getting pushed into SQL function? Jay Levitt 20:13
Re: Predicates not getting pushed into SQL function? Jay Levitt 20:15
Re: Blocking excessively in FOR UPDATE Claudio Freire 20:26
Subquery in a JOIN not getting restricted? Jay Levitt 21:25
Re: Subquery in a JOIN not getting restricted? Tom Lane 21:41
Re: Subquery in a JOIN not getting restricted? Kevin Grittner 21:53
WAL partition filling up after high WAL activity Richard Yen 22:18
Re: Subquery in a JOIN not getting restricted? Kevin Grittner 22:51
Re: Subquery in a JOIN not getting restricted? Jay Levitt 23:19

Nov. 8, 2011

Thread Author Time
Re: Subquery in a JOIN not getting restricted? Jay Levitt 01:56
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim 03:21
Re: Error while vacuuming Bhakti Ghatkar 06:33
Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!! Sam Gendler 07:19
Re: Error while vacuuming Samuel Gendler 07:49
Re: SSL encryption makes bytea transfer slow Albe Laurenz 10:25
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Lucas Mocellin 10:34
Re: SSL encryption makes bytea transfer slow Marti Raudsepp 10:51
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra 11:50
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim 12:15
Re: SSL encryption makes bytea transfer slow Albe Laurenz 12:35
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Tomas Vondra 12:40
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mario Weilguni 12:49
Re: SSL encryption makes bytea transfer slow Albe Laurenz 13:18
Trying to understand Stats/Query planner issue Strange, John W 22:33
STRICT SQL functions never inline Josh Berkus 23:29

Nov. 9, 2011

Thread Author Time
Re: STRICT SQL functions never inline Andres Freund 00:25
Re: STRICT SQL functions never inline Tom Lane 00:29
: bg_writer overloaded ? Venkat Balaji 09:25
Re: : bg_writer overloaded ? Scott Marlowe 14:46
Re: Subquery in a JOIN not getting restricted? Kevin Grittner 15:15
Re: WAL partition filling up after high WAL activity Greg Smith 16:06
Re: Heavy contgnous load kzsolt 19:48
Re: Subquery in a JOIN not getting restricted? Merlin Moncure 19:50
Re: Subquery in a JOIN not getting restricted? Kevin Grittner 20:20
Re: Subquery in a JOIN not getting restricted? Jay Levitt 20:39

Nov. 10, 2011

Thread Author Time
IMMUTABLE STABLE functions, daily updates Sorin Dudui 13:05
Re: IMMUTABLE STABLE functions, daily updates Thom Brown 13:25
Re: Subquery in a JOIN not getting restricted? Jay Levitt 13:52
Re: IMMUTABLE STABLE functions, daily updates Craig Ringer 14:28
Re: Subquery in a JOIN not getting restricted? Tom Lane 15:22
Re: Subquery in a JOIN not getting restricted? Jay Levitt 15:42

Nov. 11, 2011

Thread Author Time
Re: WAL partition filling up after high WAL activity Rafael Martinez 09:54
avoiding seq scans when two columns are very correlated Ruslan Zakirov 15:01
Re: avoiding seq scans when two columns are very correlated Tom Lane 15:36
where clause + function, execution order Sorin Dudui 15:38
Re: where clause + function, execution order Julius Tuskenis 15:54
Re: where clause + function, execution order Richard Huxton 15:59
Re: where clause + function, execution order Tom Lane 16:00
Re: where clause + function, execution order Sorin Dudui 16:28
Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov 16:39
Re: where clause + function, execution order Richard Huxton 16:55
unlogged tables Anibal David Acosta 20:08
Re: unlogged tables Stephen Frost 20:18
Using incrond for archiving Shaun Thomas 22:21

Nov. 12, 2011

Thread Author Time
Re: WAL partition filling up after high WAL activity Greg Smith 06:31
Re: Subquery in a JOIN not getting restricted? Gavin Flower 09:28

Nov. 13, 2011

Thread Author Time
Re: Heavy contgnous load Pavel Stehule 08:57
Re: Trying to understand Stats/Query planner issue Tom Lane 16:17

Nov. 14, 2011

Thread Author Time
Re: : bg_writer overloaded ? Venkat Balaji 05:54
Re: unlogged tables Sergey Konoplev 08:10
Re: unlogged tables Richard Huxton 08:58
What's the state of postgresql on ext4 now? Alexandru 10:00
Re: unlogged tables Sergey Konoplev 10:08
Re: unlogged tables Richard Huxton 10:17
Re: unlogged tables Sergey Konoplev 10:39
Re: unlogged tables Anibal David Acosta 17:05
Re: unlogged tables Kevin Grittner 17:26
Re: unlogged tables Anibal David Acosta 17:38
Re: unlogged tables Kevin Grittner 17:50
Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan 18:16
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 19:22
Re: Using incrond for archiving Shaun Thomas 21:33
Re: Using incrond for archiving Kevin Grittner 21:47
Re: Using incrond for archiving Shaun Thomas 21:58
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan 21:58
Query planner suggestion, for indexes with similar but not exact ordering. Andrew Barnham 22:22
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 22:57

Nov. 15, 2011

Thread Author Time
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan 00:13
Large number of short lived connections - could a connection pool help? Cody Caughlan 00:42
Re: Large number of short lived connections - could a connection pool help? Ben Chobot 00:59
Re: Large number of short lived connections - could a connection pool help? Cody Caughlan 01:04
Re: avoiding seq scans when two columns are very correlated Stuart Bishop 07:08
Re: What's the state of postgresql on ext4 now? Maciek Sakrejda 07:32
Re: Large number of short lived connections - could a connection pool help? Mario Weilguni 08:04
Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov 15:04
Re: What's the state of postgresql on ext4 now? Josh Berkus 20:48
Re: unlogged tables Josh Berkus 20:51
Re: What's the state of postgresql on ext4 now? Scott Marlowe 20:54

Nov. 16, 2011

Thread Author Time
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 01:02
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 01:16
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan 01:21
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 02:16
Re: What's the state of postgresql on ext4 now? Greg Smith 03:48
Re: What's the state of postgresql on ext4 now? Aidan Van Dyk 03:54
Re: What's the state of postgresql on ext4 now? Scott Marlowe 03:55
Re: Slow queries / commits, mis-configuration or hardware issues? Greg Smith 04:27
Re: What's the state of postgresql on ext4 now? Greg Smith 06:51
Re: Subquery in a JOIN not getting restricted? Jay Levitt 14:06
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 16:34
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 16:52
Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan 17:31
Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra 18:16
Performance question 83 GB Table 150 million rows, distinct select Tory M Blue 22:53
Re: Performance question 83 GB Table 150 million rows, distinct select Alan Hodgson 23:27

Browse Archives

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