pgsql-performance since 2010-07-28 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

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

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

Browse Archives

Prev | Next