Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - August 2010

Prev | Next

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

Aug. 1, 2010

what does "initplan" operation in explain output mean? Mark Rostron (06:36)
Re: what does "initplan" operation in explain output mean? Tom Lane (14:08)

Aug. 2, 2010

Re: Testing Sandforce SSD Merlin Moncure (14:26)
Re: Testing Sandforce SSD Yeb Havinga (15:00)
Re: what does "initplan" operation in explain output mean? Mark Rostron (16:42)
Re: what does "initplan" operation in explain output mean? Tom Lane (17:29)
Optimizing NOT IN plans / verify rewrite Maciek Sakrejda (19:12)
Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner (19:29)
Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda (19:42)
Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner (19:49)
Re: Optimizing NOT IN plans / verify rewrite Andres Freund (19:52)
Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda (20:06)
Re: Optimizing NOT IN plans / verify rewrite Dave Crooke (20:14)
Re: Optimizing NOT IN plans / verify rewrite Andres Freund (20:21)
Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda (20:35)
Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner (21:03)
Re: Questions on query planner, join types, and work_mem Peter Hussey (21:23)
Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner (21:23)
Re: Optimizing NOT IN plans / verify rewrite Kevin Grittner (21:38)
Re: Optimizing NOT IN plans / verify rewrite Andres Freund (22:19)
Re: Testing Sandforce SSD Josh Berkus (22:21)
Re: Optimizing NOT IN plans / verify rewrite Maciek Sakrejda (22:37)

Aug. 3, 2010

Re: Testing Sandforce SSD Greg Smith (00:07)
Re: Testing Sandforce SSD Scott Marlowe (00:12)
Re: Questions on query planner, join types, and work_mem Robert Haas (02:48)
Re: Questions on query planner, join types, and work_mem Tom Lane (02:55)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (07:03)
Re: Testing Sandforce SSD Yeb Havinga (08:40)
Re: Testing Sandforce SSD Hannu Krosing (09:08)
Re: Testing Sandforce SSD Yeb Havinga (11:19)
Re: Testing Sandforce SSD Greg Smith (14:02)
Re: Testing Sandforce SSD Yeb Havinga (15:37)
Re: Testing Sandforce SSD Merlin Moncure (16:27)
Re: Testing Sandforce SSD Chris Browne (16:58)
Re: Testing Sandforce SSD Chris Browne (17:04)

Aug. 4, 2010

Re: Execution Plan Rodrigo E. De León Plicet (03:29)
performance sol10 zone (fup) Heiko L. (07:16)
Re: Questions on query planner, join types, and work_mem Robert Haas (13:14)
Re: Strange explain on partitioned tables Robert Haas (13:16)
Re: Questions on query planner, join types, and work_mem Kevin Grittner (14:01)
LIKE without wildcard different from = Kevin Grittner (16:34)
Re: LIKE without wildcard different from = Tom Lane (16:41)
Re: LIKE without wildcard different from = Kevin Grittner (16:52)
Re: LIKE without wildcard different from = Tom Lane (16:58)
Re: LIKE without wildcard different from = Kevin Grittner (17:00)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (17:51)
Re: Questions on query planner, join types, and work_mem Tom Lane (18:00)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (18:41)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (19:03)
Re: Questions on query planner, join types, and work_mem Greg Smith (19:16)
Re: Questions on query planner, join types, and work_mem Greg Smith (19:18)
Re: Questions on query planner, join types, and work_mem Tom Lane (19:20)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (19:38)
Re: Testing Sandforce SSD Scott Carey (19:43)
Re: Testing Sandforce SSD Scott Carey (19:49)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (19:51)
Re: Questions on query planner, join types, and work_mem Kevin Grittner (19:58)
Re: Testing Sandforce SSD Scott Carey (19:58)
Re: Questions on query planner, join types, and work_mem Hannu Krosing (20:24)
Re: Questions on query planner, join types, and work_mem Greg Smith (20:38)
Re: Questions on query planner, join types, and work_mem Greg Smith (20:40)
Re: Questions on query planner, join types, and work_mem Kevin Grittner (20:42)
Re: Questions on query planner, join types, and work_mem Kevin Grittner (20:46)

Aug. 5, 2010

Re: Testing Sandforce SSD Brad Nicholson (12:40)
vacuum performance on insert Sean Chen (17:49)
Re: vacuum performance on insert Kevin Grittner (17:56)
Re: vacuum performance on insert Tom Lane (18:11)
Advice configuring ServeRAID 8k for performance Kenneth Cox (18:28)
Two fast searches turn slow when used with OR clause Craig James (18:34)
Re: Advice configuring ServeRAID 8k for performance Alan Hodgson (18:53)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (19:25)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (19:40)
Re: Advice configuring ServeRAID 8k for performance Pierre C (22:27)
Re: Advice configuring ServeRAID 8k for performance Craig James (22:52)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (23:09)
Re: Advice configuring ServeRAID 8k for performance Dave Crooke (23:13)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (23:24)
Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood (23:32)
Re: Advice configuring ServeRAID 8k for performance Alan Hodgson (23:58)

Aug. 6, 2010

Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood (00:31)
Re: Advice configuring ServeRAID 8k for performance Mark Kirkwood (00:35)
Re: Advice configuring ServeRAID 8k for performance Matthew Wakeling (09:17)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (16:39)
Re: Advice configuring ServeRAID 8k for performance Justin Pitts (17:32)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (17:59)
Re: Advice configuring ServeRAID 8k for performance Justin Pitts (18:17)

Aug. 7, 2010

Re: vacuum performance on insert Sean Chen (04:32)
Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March (23:47)

Aug. 8, 2010

Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (06:36)
Re: Advice configuring ServeRAID 8k for performance Scott Carey (06:46)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March (06:49)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe (06:55)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March (07:03)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe (07:30)
Re: Advice configuring ServeRAID 8k for performance Scott Marlowe (07:50)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Yeb Havinga (10:12)

Aug. 9, 2010

Re: vacuum performance on insert Kevin Grittner (14:03)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (16:49)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Jeff Davis (22:41)

Aug. 10, 2010

Sorted group by Matthew Wakeling (15:40)
Re: Sorted group by Thomas Kellerer (15:56)
Re: Sorted group by Matthew Wakeling (16:03)
Re: Sorted group by Thom Brown (16:06)
Re: Sorted group by hubert depesz lubaczewski (16:11)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith (16:21)
Re: Sorted group by Thomas Kellerer (16:22)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith (16:27)
Re: Sorted group by Thom Brown (16:28)
Re: Sorted group by Kevin Grittner (16:37)
Re: Sorted group by Jonathan Blitz (17:38)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson (17:57)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger (18:13)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe (18:23)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith (18:28)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger (18:38)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson (18:47)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson (18:54)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger (19:28)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson (19:51)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe (19:52)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Christopher Browne (20:00)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Marlowe (20:06)

Aug. 11, 2010

Re: Sorted group by Matthew Wakeling (13:46)
32 vs 64 bit build on Solaris Sparc Joseph Conway (15:17)
Re: 32 vs 64 bit build on Solaris Sparc Tom Lane (15:23)
Re: Sorted group by Alvaro Herrera (15:54)
Re: Testing Sandforce SSD Bruce Momjian (22:31)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (23:05)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (23:10)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (23:52)

Aug. 12, 2010

Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Karl Denninger (00:45)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD gnuoytr (00:53)
Re: Questions on query planner, join types, and work_mem Bruce Momjian (01:42)
Re: Questions on query planner, join types, and work_mem Robert Haas (02:39)
Re: performance sol10 zone (fup) Robert Haas (03:16)
Re: performance sol10 zone (fup) Scott Marlowe (04:12)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith (04:30)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Greg Smith (04:49)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Arjen van der Meijden (07:22)
Re: 32 vs 64 bit build on Solaris Sparc Dimitri (07:32)
Re: Slow function in queries SELECT clause. Davor J. (12:00)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Brad Nicholson (12:35)
Very bad plan when using VIEW and IN (SELECT...*) Carlo Stonebanks (21:47)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Scott Carey (23:40)

Aug. 13, 2010

Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Arjen van der Meijden (05:59)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD Michael March (06:06)
Re: Very bad plan when using VIEW and IN (SELECT...*) Kevin Grittner (13:28)
Re: Very bad plan when using VIEW and IN (SELECT...*) Carlo Stonebanks (14:51)
Can WINDOW be used? Greg Spiegelberg (16:43)
Re: Advice configuring ServeRAID 8k for performance Bruce Momjian (18:17)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (18:41)
Re: Can WINDOW be used? Josh Berkus (21:17)

Aug. 16, 2010

Re: Advice configuring ServeRAID 8k for performance Scott Carey (16:28)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (17:46)
Re: Advice configuring ServeRAID 8k for performance Andres Freund (20:02)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (20:13)
Re: Advice configuring ServeRAID 8k for performance Andres Freund (20:18)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (20:54)
Re: Advice configuring ServeRAID 8k for performance Andres Freund (21:05)

Aug. 17, 2010

Very poor performance Aaron Burnett (01:06)
Re: Advice configuring ServeRAID 8k for performance Bruce Momjian (01:31)
Re: Very poor performance Mark Rostron (01:51)
Re: Very poor performance Aaron Burnett (02:19)
Quesion on the use of indexes Benjamin Krajmalnik (03:22)
Re: Quesion on the use of indexes Tom Lane (03:33)
Search query is curious fiala_marek (07:26)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (08:29)
Re: Advice configuring ServeRAID 8k for performance Greg Smith (08:42)
Re: Advice configuring ServeRAID 8k for performance Andres Freund (09:37)
Re: Search query is curious Thom Brown (10:44)
Re: Search query is curious Pavel Stehule (10:49)
Re: Very poor performance Kevin Grittner (14:18)
Re: Quesion on the use of indexes Alvaro Herrera (15:07)
Re: Search query is curious Maciek Sakrejda (15:16)
Re: Quesion on the use of indexes gnuoytr (15:27)
Re: Very poor performance Kevin Grittner (15:43)
Re: Very poor performance Tom Lane (15:57)
Re: Very poor performance Mark Rostron (16:21)
Re: Very poor performance Aaron Burnett (17:54)
Re: Very poor performance Kevin Grittner (18:19)
Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes (19:19)
Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows Scott Marlowe (19:24)
Re: Very poor performance Mark Kirkwood (22:27)

Aug. 18, 2010

Re: Very poor performance Kevin Grittner (03:08)
Re: Two fast searches turn slow when used with OR clause Robert Haas (03:22)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD david (06:37)
Re: Very poor performance Hannes Frederic Sowa (11:48)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD gnuoytr (11:49)
Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Alexandre de Arruda Paes (13:07)
Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows Tom Lane (13:22)
Are Indices automatically generated for primary keys? Clemens Eisserer (13:51)
Re: Are Indices automatically generated for primary keys? hubert depesz lubaczewski (13:54)
Re: Are Indices automatically generated for primary keys? Kevin Grittner (13:59)
Re: Are Indices automatically generated for primary keys? Clemens Eisserer (14:15)
Re: Are Indices automatically generated for primary keys? Kevin Grittner (14:24)
Re: [PERFORM] Are Indices automatically generated for primary keys? Clemens Eisserer (14:33)
Re: Are Indices automatically generated for primary keys? Kevin Grittner (14:52)
Re: Are Indices automatically generated for primary keys? Thom Brown (15:23)
Re: Are Indices automatically generated for primary keys? Justin Graf (16:06)
Copy performance issues Saadat Anwar (16:25)

Prev | Next

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group