pgsql-performance since 2010-07-19 00:00

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

July 19, 2010

Thread Author Time
Re: Pooling in Core WAS: Need help in performance tuning. Tatsuo Ishii 02:16
Re: Pooling in Core WAS: Need help in performance tuning. Rajesh Kumar Mallah 02:36
Re: Pooling in Core WAS: Need help in performance tuning. Tatsuo Ishii 02:50
Re: What is the best way to optimize the query. Sergey Konoplev 06:07
Re: What is the best way to optimize the query. Craig Ringer 06:08
how to handle a big table for data log kuopo 06:27
IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima 12:24
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Kevin Grittner 13:28
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima 14:20
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Greg Smith 14:38
Big field, limiting and ordering Ivan Voras 15:09
Re: Big field, limiting and ordering Vitalii Tymchyshyn 15:35
Re: how to handle a big table for data log Jorge Montero 15:37
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima 19:53

July 20, 2010

Thread Author Time
dates and partitioning Kevin Kempter 15:36
Re: dates and partitioning Brad Nicholson 15:55
Re: dates and partitioning Jochen Erwied 15:55
potential performance gain by query planner optimization Kneringer, Armin 16:25
Re: potential performance gain by query planner optimization Pavel Stehule 19:39
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Scott Carey 22:58

July 21, 2010

Thread Author Time
Re: how to handle a big table for data log kuopo 03:51
Using more tha one index per table Elias Ghanem 07:31
Re: Using more tha one index per table A. Kretschmer 07:53
Re: Using more tha one index per table Rob Wultsch 07:58
Re: Using more tha one index per table Scott Marlowe 08:01
Re: Using more tha one index per table Scott Marlowe 08:03
tune memory usage for master/slave nodes in cluster stanimir petrov 12:42
Re: Using more tha one index per table Andy Colson 14:14
Re: Using more tha one index per table Greg Smith 14:59
Re: tune memory usage for master/slave nodes in cluster Greg Smith 15:08
Re: potential performance gain by query planner optimization Kneringer, Armin 16:47
Re: potential performance gain by query planner optimization Pavel Stehule 17:21

July 22, 2010

Thread Author Time
Re: Using more tha one index per table Craig Ringer 00:47
Re: Using more tha one index per table Craig James 01:03
Re: Using more tha one index per table Greg Smith 01:47
Re: Using more tha one index per table Steve Atkins 02:00
Re: Using more tha one index per table Greg Smith 02:27
Re: Using more tha one index per table Steve Atkins 02:55
Strange explain on partitioned tables Philippe Rimbault 07:52
why index is not working in < operation? AI Rumman 08:05
Re: why index is not working in < operation? Szymon Guz 08:11
Re: why index is not working in < operation? A. Kretschmer 08:16
Re: [PERFORM] Using more tha one index per table Richard Huxton 08:35
Re: Strange explain on partitioned tables Philippe Rimbault 08:57
Re: [PERFORM] Using more tha one index per table Rob Wultsch 09:09
Re: Strange explain on partitioned tables Philippe Rimbault 10:03
Re: Strange explain on partitioned tables Greg Smith 13:32
Re: Strange explain on partitioned tables Philippe Rimbault 14:10
Re: Using more tha one index per table Craig James 16:57
Re: Slow query with planner row strange estimation Robert Haas 18:08
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 18:33
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 18:36
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake 19:15
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 19:15
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 19:56
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund 21:29
Re: Pooling in Core WAS: Need help in performance tuning. Scott Carey 21:44

July 23, 2010

Thread Author Time
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 00:57
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 01:00
Execution Plan std pik 04:06
Re: Execution Plan Pavel Stehule 07:43
Re: Using more tha one index per table Torsten Zühlsdorff 09:22
Re: Pooling in Core WAS: Need help in performance tuning. Joshua Tolley 15:55
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 15:58
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake 16:52
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 17:28
Re: Using more tha one index per table Craig James 21:47
Re: Strange explain on partitioned tables Gerald Fontenay 22:03
Re: Strange explain on partitioned tables Joshua D. Drake 22:16

July 24, 2010

Thread Author Time
Re: Strange explain on partitioned tables Greg Smith 05:12
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund 05:13
Re: Pooling in Core WAS: Need help in performance tuning. Greg Smith 05:23
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund 05:32
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer 06:23
Re: Strange explain on partitioned tables Gerald Fontenay 06:29
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer 06:36
Testing Sandforce SSD Yeb Havinga 07:20
Re: Testing Sandforce SSD David Boreham 07:37
Re: Testing Sandforce SSD david 08:25
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 09:52
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing 10:07
Re: Using more tha one index per table Torsten Zühlsdorff 12:57
Re: Using more tha one index per table Craig James 14:59
Re: Testing Sandforce SSD Ben Chobot 16:50
Re: Testing Sandforce SSD Greg Smith 17:14
Re: Testing Sandforce SSD Merlin Moncure 18:06
Re: Testing Sandforce SSD Yeb Havinga 19:49
Re: Testing Sandforce SSD Yeb Havinga 19:54
Re: Testing Sandforce SSD Greg Smith 20:21
Re: Testing Sandforce SSD Joshua D. Drake 21:09
Re: Testing Sandforce SSD Greg Smith 21:14
Re: Testing Sandforce SSD Yeb Havinga 21:22
Re: Testing Sandforce SSD Greg Smith 22:01

July 25, 2010

Thread Author Time
Re: Using more tha one index per table Dimitri Fontaine 08:29
Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine 08:40
Slow query using the Cube contrib module. Liviu Mirea-Ghiban 10:32
Re: Testing Sandforce SSD Yeb Havinga 18:35
Re: Testing Sandforce SSD Yeb Havinga 19:13
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 22:09

July 26, 2010

Thread Author Time
Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło 08:35
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło 08:44
Explains of queries to partitioned tables Vlad Arkhipov 08:47
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer 09:15
Re: Testing Sandforce SSD Yeb Havinga 09:22
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn 09:25
Re: Testing Sandforce SSD Matthew Wakeling 09:47
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer 09:56
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło 10:04
Re: Testing Sandforce SSD Yeb Havinga 10:29
Re: Testing Sandforce SSD Greg Smith 15:28
Re: Testing Sandforce SSD Greg Smith 15:34
Re: Testing Sandforce SSD Matthew Wakeling 15:42
Re: Testing Sandforce SSD Yeb Havinga 16:26
Re: Testing Sandforce SSD Greg Spiegelberg 16:26
Re: Testing Sandforce SSD Greg Smith 18:34
Re: Testing Sandforce SSD Greg Smith 18:40
Re: Testing Sandforce SSD Kevin Grittner 18:42
Re: Testing Sandforce SSD Yeb Havinga 19:42
Re: Testing Sandforce SSD Yeb Havinga 19:43
Re: Testing Sandforce SSD Greg Smith 19:45
Re: Testing Sandforce SSD Scott Marlowe 19:47
Re: Testing Sandforce SSD Hannu Krosing 20:40
Re: Testing Sandforce SSD Greg Spiegelberg 21:23
Re: Strange explain on partitioned tables Gerald Fontenay 21:26
Re: Testing Sandforce SSD Andres Freund 22:28
Re: Testing Sandforce SSD Greg Smith 23:00
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Lew 23:03

July 27, 2010

Thread Author Time
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Tom Lane 04:19
Linux Filesystems again - Ubuntu this time Mark Kirkwood 05:04
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner 13:48
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong 16:57
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner 17:10
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner 17:19
Re: What is the best way to optimize the query. Robert Haas 18:11
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong 18:20
Re: potential performance gain by query planner optimization Tom Lane 18:25
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner 18:32
Re: how to handle a big table for data log Greg Spiegelberg 20:02
Re: Slow query using the Cube contrib module. Yeb Havinga 20:06
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane 20:40
Re: how to handle a big table for data log Josh Berkus 21:13
Re: Slow query using the Cube contrib module. Tom Lane 22:18
Questions on query planner, join types, and work_mem Peter Hussey 23:08
Re: Questions on query planner, join types, and work_mem Andres Freund 23:57

July 28, 2010

Thread Author Time
Re: Questions on query planner, join types, and work_mem Tom Lane 00:05
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 01:44
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane 01:56
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 02:05
Re: Questions on query planner, join types, and work_mem Alvaro Herrera 04:01
Re: Questions on query planner, join types, and work_mem Jayadevan M 04:27
Re: Questions on query planner, join types, and work_mem Tom Lane 04:39
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane 05:09
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer 05:23
158x query improvement when removing 2 (noop) WHERE conditions Louis-David Mitterrand 10:27
Re: 158x query improvement when removing 2 (noop) WHERE conditions Andres Freund 10:49
Re: Pooling in Core WAS: Need help in performance tuning. Vitalii Tymchyshyn 11:03
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn 11:07
Re: Testing Sandforce SSD Michael Stone 12:21
Re: Testing Sandforce SSD Michael Stone 12:24
Re: Testing Sandforce SSD Yeb Havinga 13:45
Re: Testing Sandforce SSD Yeb Havinga 15:18
Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus 19:44
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 19:52
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane 20:10
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund 20:19

July 29, 2010

Thread Author Time
planner index choice Chris 00:51
Re: Testing Sandforce SSD Greg Spiegelberg 02:07
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas 03:16
Re: planner index choice Tom Lane 03:53
Re: planner index choice Chris 07:29
Re: planner index choice tv 11:14
Re: Testing Sandforce SSD Michael Stone 14:45
Re: planner index choice Tom Lane 15:20
On Scalability Vincenzo Romano 17:08
Re: On Scalability Joshua D. Drake 17:12
Re: On Scalability Vincenzo Romano 17:34
Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus 17:39
Re: On Scalability Joshua D. Drake 17:39
Re: On Scalability Vincenzo Romano 17:52
Re: On Scalability Joshua D. Drake 18:16
Re: On Scalability Josh Berkus 20:09
Re: On Scalability Vincenzo Romano 21:30
How to improve: performance of query on postgresql 8.3 takes days Dino Vliet 21:58
Re: How to improve: performance of query on postgresql 8.3 takes days John R Pierce 22:17

July 30, 2010

Thread Author Time
Re: How to improve: performance of query on postgresql 8.3 takes days A. Kretschmer 06:11
Re: On Scalability Vincenzo Romano 10:24
Re: How to improve: performance of query on postgresql 8.3 takes days Alban Hertroys 10:48
Re: On Scalability Greg Stark 10:49
Re: On Scalability Vincenzo Romano 11:40
Re: Questions on query planner, join types, and work_mem Tom Lane 14:03
view columns and performance Eric Schwarzenbach 14:55
Re: Testing Sandforce SSD Yeb Havinga 15:01
Re: view columns and performance Tom Lane 15:11
Re: Testing Sandforce SSD 📎 Karl Denninger 15:14
Re: On Scalability Josh Berkus 18:51
Re: On Scalability Vincenzo Romano 19:50
Re: On Scalability Greg Smith 20:38
Re: On Scalability Robert Haas 20:39

July 31, 2010

Thread Author Time
Re: Explains of queries to partitioned tables Robert Haas 02:21
what does "initplan" operation in explain output mean? Mark Rostron 02:27

Browse Archives

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