Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2010-07 Chronological Index (1/3)
Last updated: Wed Jan 18 04:13:30 2012
454 messages
30 July 2010
Re: view columns and performance Tom Lane (15:11)
view columns and performance Eric Schwarzenbach (15:02)
Re: Testing Sandforce SSD Yeb Havinga (15:00)
Re: Questions on query planner, join types, and work_mem Tom Lane (14:04)
29 July 2010
Re: planner index choice Tom Lane (15:21)
Re: Testing Sandforce SSD Michael Stone (14:46)
Re: planner index choice tv (11:15)
Re: planner index choice Chris (07:29)
Re: planner index choice Tom Lane (03:53)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (03:16)
Re: Testing Sandforce SSD Greg Spiegelberg (02:07)
planner index choice Chris (00:51)
28 July 2010
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane (20:10)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (19:52)
Re: Pooling in Core WAS: Need help in performance tuning. Josh Berkus (19:45)
Re: Testing Sandforce SSD Yeb Havinga (15:17)
Re: Testing Sandforce SSD Yeb Havinga (13:43)
Re: Testing Sandforce SSD Michael Stone (13:24)
Re: Testing Sandforce SSD Michael Stone (13:22)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn (11:07)
Re: Pooling in Core WAS: Need help in performance tuning. Vitalii Tymchyshyn (11:04)
Re: 158x query improvement when removing 2 (noop) WHERE conditions Andres Freund (10:49)
158x query improvement when removing 2 (noop) WHERE conditions Louis-David Mitterrand (10:27)
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer (05:30)
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane (05:09)
Re: Questions on query planner, join types, and work_mem Tom Lane (04:39)
Re: Questions on query planner, join types, and work_mem Jayadevan M (04:29)
Re: Questions on query planner, join types, and work_mem Alvaro Herrera (04:02)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (02:05)
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane (01:57)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (01:44)
Re: Questions on query planner, join types, and work_mem Tom Lane (00:05)
27 July 2010
Questions on query planner, join types, and work_mem Peter Hussey (23:34)
Re: Slow query using the Cube contrib module. Tom Lane (22:19)
Re: how to handle a big table for data log Josh Berkus (21:17)
Re: Pooling in Core WAS: Need help in performance tuning. Tom Lane (20:40)
Re: Slow query using the Cube contrib module. Yeb Havinga (20:04)
Re: how to handle a big table for data log Greg Spiegelberg (20:02)
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner (18:32)
Re: potential performance gain by query planner optimization Tom Lane (18:25)
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong (18:20)
Re: What is the best way to optimize the query. Robert Haas (18:11)
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner (17:19)
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner (17:11)
Re: Linux Filesystems again - Ubuntu this time Whit Armstrong (16:57)
Re: Linux Filesystems again - Ubuntu this time Kevin Grittner (13:49)
Linux Filesystems again - Ubuntu this time Mark Kirkwood (05:04)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Tom Lane (04:19)
26 July 2010
Re: Testing Sandforce SSD Greg Smith (23:01)
Re: Testing Sandforce SSD Andres Freund (22:28)
Re: Strange explain on partitioned tables Gerald Fontenay (21:25)
Re: Testing Sandforce SSD Greg Spiegelberg (21:23)
Re: Testing Sandforce SSD Hannu Krosing (20:41)
Re: Testing Sandforce SSD Scott Marlowe (19:47)
Re: Testing Sandforce SSD Greg Smith (19:45)
Re: Testing Sandforce SSD Yeb Havinga (19:42)
Re: Testing Sandforce SSD Yeb Havinga (19:40)
Re: Testing Sandforce SSD Kevin Grittner (18:42)
Re: Testing Sandforce SSD Greg Smith (18:40)
Re: Testing Sandforce SSD Greg Smith (18:34)
Re: Testing Sandforce SSD Greg Spiegelberg (16:27)
Re: Testing Sandforce SSD Yeb Havinga (16:25)
Re: Testing Sandforce SSD Matthew Wakeling (15:42)
Re: Testing Sandforce SSD Greg Smith (15:34)
Re: Testing Sandforce SSD Greg Smith (15:28)
Re: Testing Sandforce SSD Yeb Havinga (10:28)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło (10:04)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer (09:57)
Re: Testing Sandforce SSD Matthew Wakeling (09:47)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Vitalii Tymchyshyn (09:25)
Re: Testing Sandforce SSD Yeb Havinga (09:21)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Craig Ringer (09:15)
Explains of queries to partitioned tables Vlad Arkhipov (09:07)
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło (08:44)
Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Piotr Gasidło (08:35)
25 July 2010
Re: Testing Sandforce SSD Yeb Havinga (19:11)
Re: Testing Sandforce SSD Yeb Havinga (18:33)
Slow query using the Cube contrib module. Liviu Mirea-Ghiban (10:35)
Re: Pooling in Core WAS: Need help in performance tuning. Dimitri Fontaine (08:40)
Re: Using more tha one index per table Dimitri Fontaine (08:29)
24 July 2010
Re: Testing Sandforce SSD Yeb Havinga (21:20)
Re: Testing Sandforce SSD Greg Smith (21:16)
Re: Testing Sandforce SSD Joshua D. Drake (21:09)
Re: Testing Sandforce SSD Greg Smith (20:21)
Re: Testing Sandforce SSD Yeb Havinga (19:53)
Re: Testing Sandforce SSD Yeb Havinga (19:48)
Re: Testing Sandforce SSD Merlin Moncure (18:07)
Re: Testing Sandforce SSD Greg Smith (17:14)
Re: Testing Sandforce SSD Ben Chobot (16:50)
Re: Using more tha one index per table Craig James (14:59)
Re: Using more tha one index per table Torsten Zühlsdorff (13:25)
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing (10:07)
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing (09:52)
Re: Testing Sandforce SSD david (08:40)
Re: Testing Sandforce SSD David Boreham (07:37)
Testing Sandforce SSD Yeb Havinga (07:19)
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer (06:36)
Re: Pooling in Core WAS: Need help in performance tuning. Craig Ringer (06:23)
Re: Strange explain on partitioned tables Gerald Fontenay (05:38)
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund (05:32)
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:14)
Re: Strange explain on partitioned tables Greg Smith (05:12)
23 July 2010
Re: Strange explain on partitioned tables Gerald Fontenay (22:12)
Re: Using more tha one index per table Craig James (21:47)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (17:29)
Re: Pooling in Core WAS: Need help in performance tuning. Joshua D. Drake (16:53)
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 Tolley (15:55)
Re: Using more tha one index per table Torsten Zühlsdorff (09:25)
Re: Execution Plan Pavel Stehule (07:43)
Execution Plan std pik (04:25)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (01:01)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (00:58)
22 July 2010
Re: Pooling in Core WAS: Need help in performance tuning. Andres Freund (21:30)
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing (19:56)
Re: Pooling in Core WAS: Need help in performance tuning. Hannu Krosing (19:15)
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. Robert Haas (19:02)
Re: Pooling in Core WAS: Need help in performance tuning. Robert Haas (19:01)
Re: Slow query with planner row strange estimation Robert Haas (18:09)
Re: Using more tha one index per table Craig James (16:57)
Re: Strange explain on partitioned tables Philippe Rimbault (14:09)
Re: Strange explain on partitioned tables Greg Smith (13:32)
Re: Strange explain on partitioned tables Philippe Rimbault (10:02)
Re: Using more tha one index per table Rob Wultsch (09:09)
Re: Strange explain on partitioned tables Philippe Rimbault (08:56)
Re: Using more tha one index per table Richard Huxton (08:35)
Re: why index is not working in < operation? A. Kretschmer (08:16)
Re: why index is not working in < operation? Szymon Guz (08:11)
why index is not working in < operation? AI Rumman (08:05)
Strange explain on partitioned tables Philippe Rimbault (07:51)
Re: Using more tha one index per table Steve Atkins (02:55)
Re: Using more tha one index per table Greg Smith (02:28)
Re: Using more tha one index per table Steve Atkins (02:00)
Re: Using more tha one index per table Greg Smith (01:47)
Re: Using more tha one index per table Craig James (01:03)
Re: Using more tha one index per table Craig Ringer (00:48)
21 July 2010
Re: potential performance gain by query planner optimization Kneringer, Armin (16:48)
Re: tune memory usage for master/slave nodes in cluster Greg Smith (15:08)
Re: Using more tha one index per table Greg Smith (15:00)
Re: Using more tha one index per table Andy Colson (14:14)
tune memory usage for master/slave nodes in cluster stanimir petrov (12:42)
Re: Using more tha one index per table Scott Marlowe (08:03)
Re: Using more tha one index per table Scott Marlowe (08:01)
Re: Using more tha one index per table Rob Wultsch (07:58)
Re: Using more tha one index per table A. Kretschmer (07:54)
Using more tha one index per table Elias Ghanem (07:31)
Re: how to handle a big table for data log kuopo (03:51)
20 July 2010
Re: potential performance gain by query planner optimization Pavel Stehule (19:39)
potential performance gain by query planner optimization Kneringer, Armin (16:48)
Re: dates and partitioning Jochen Erwied (15:56)
Re: dates and partitioning Brad Nicholson (15:55)
dates and partitioning Kevin Kempter (15:42)
19 July 2010
Re: how to handle a big table for data log Jorge Montero (15:39)
Re: Big field, limiting and ordering Vitalii Tymchyshyn (15:35)
Big field, limiting and ordering Ivan Voras (15:09)
Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Greg Smith (14:38)
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 Kevin Grittner (13:28)
IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem Daniel Ferreira de Lima (12:24)
how to handle a big table for data log kuopo (06:27)
Re: What is the best way to optimize the query. Craig Ringer (06:16)
Re: What is the best way to optimize the query. Sergey Konoplev (06:16)
Re: Pooling in Core WAS: Need help in performance tuning. Tatsuo Ishii (02:50)
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:15)