pgsql-performance - August 2010

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 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2010

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Thread Author Time
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

Browse Archives

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