pgsql-performance - December 2009

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 23 24 25 26 27 28 29

Dec. 1, 2009

Thread Author Time
Re: Server Freezing Greg Smith 00:08
Server Freezing Waldomiro 01:02
Re: Server Freezing Waldomiro 11:02
Re: Server Freezing 📎 Waldomiro 11:18
Re: Server Freezing Fernando Hevia 15:50
Order by (for 15 rows) adds 30 seconds to query time Richard Neill 18:52
Re: Order by (for 15 rows) adds 30 seconds to query time Jean-Michel Pouré 20:06
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 20:06
Re: Order by (for 15 rows) adds 30 seconds to query time Richard Neill 22:46
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 23:36

Dec. 2, 2009

Thread Author Time
Re: RAID card recommendation Scott Carey 01:37
Re: RAID card recommendation 📎 Karl Denninger 02:08
Re: RAID card recommendation Greg Smith 02:49
Re: Order by (for 15 rows) adds 30 seconds to query time Richard Neill 05:42
Re: Order by (for 15 rows) adds 30 seconds to query time Matthew Wakeling 11:08
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 11:13
Re: Cost of sort/order by not estimated by the query planner Greg Stark 12:42
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 12:47
Re: Cost of sort/order by not estimated by the query planner Greg Stark 12:47
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 13:01
Re: Cost of sort/order by not estimated by the query planner Robert Haas 13:17
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 13:20
Re: Order by (for 15 rows) adds 30 seconds to query time Craig Ringer 13:46
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 15:32
Re: Cost of sort/order by not estimated by the query planner Robert Haas 16:47
Re: Cost of sort/order by not estimated by the query planner Tom Lane 17:01
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 18:47
Re: Order by (for 15 rows) adds 30 seconds to query time Tom Lane 20:25
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 21:33
Re: Order by (for 15 rows) adds 30 seconds to query time Tom Lane 21:48
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 22:02
Re: Order by (for 15 rows) adds 30 seconds to query time 📎 Richard Neill 23:04
Re: Order by (for 15 rows) adds 30 seconds to query time Kevin Grittner 23:31
performance while importing a very large data set in to database Ashish Kumar Singh 23:31

Dec. 3, 2009

Thread Author Time
Re: Order by (for 15 rows) adds 30 seconds to query time Richard Neill 01:31
Re: Query times change by orders of magnitude as DB ages Scott Carey 03:15
Re: Analyse without locking? Richard Neill 06:23
Re: Cost of sort/order by not estimated by the query planner Hitoshi Harada 06:58
Re: Checkpoint spikes Greg Smith 07:04
BUG #5228: Execution of prepared query is slow when timestamp parameter is used aftab 08:25
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 08:51
Re: [BUGS] BUG #5228: Execution of prepared query is slow when timestamp parameter is used Craig Ringer 08:52
Re: Cost of sort/order by not estimated by the query planner Laurent Laborde 09:08
Re: Analyse without locking? Laurent Laborde 09:44
Re: Checkpoint spikes Heikki Linnakangas 11:27
Re: Checkpoint spikes Greg Smith 20:57

Dec. 4, 2009

Thread Author Time
Re: SSD + RAID Scott Carey 00:04
query cost too high, anyway to reduce it nair rajiv 10:15
Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Andreas Thiel 23:03

Dec. 5, 2009

Thread Author Time
Time Profiling inside the procedure niraj patel 01:18
Re: performance while importing a very large data set in to database Ing . Marcos Luís Ortíz Valmaseda 14:16
Re: performance while importing a very large data set in to database Jeremy Harris 19:25
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Andres Freund 20:00
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Scott Marlowe 20:39
Re: performance while importing a very large data set in to database Scott Marlowe 20:42
Re: query cost too high, anyway to reduce it Scott Marlowe 20:45
Re: performance while importing a very large data set in to database Scott Marlowe 23:09

Dec. 6, 2009

Thread Author Time
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Craig Ringer 01:15
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Greg Smith 01:33
Re: performance while importing a very large data set in to database Pierre Frédéric Caillaud 14:14
Re: performance while importing a very large data set in to database Kris Kewley 14:15
Re: performance while importing a very large data set in to database Greg Smith 15:15
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Andres Freund 16:51
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Andres Freund 19:09
Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum Scott Marlowe 20:24

Dec. 7, 2009

Thread Author Time
Load experimentation Ben Brehmer 18:12
Re: Load experimentation Kevin Grittner 18:33
Re: Load experimentation Scott Mead 18:33
Re: Load experimentation Thom Brown 18:39
Re: Load experimentation Ben Brehmer 18:45
Re: Load experimentation Craig James 18:50
Re: RAID card recommendation Scott Carey 19:04
Re: RAID card recommendation Scott Carey 19:10
Re: Load experimentation Ben Brehmer 19:12
Re: Load experimentation Craig James 19:21
Re: RAID card recommendation 📎 Karl Denninger 19:47
Re: Load experimentation Alan Hodgson 19:48
Re: Load experimentation Greg Smith 20:59
Re: RAID card recommendation Greg Smith 21:17
Re: RAID card recommendation Craig James 21:53
performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 22:05
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Kevin Grittner 22:19
Re: RAID card recommendation 📎 Karl Denninger 22:31
Re: RAID card recommendation Greg Smith 22:43
Re: RAID card recommendation Greg Smith 22:57
Re: RAID card recommendation 📎 Karl Denninger 23:12
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 23:17
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Andres Freund 23:25

Dec. 8, 2009

Thread Author Time
Dynamlically updating the estimated cost of a transaction Hasini Gunasinghe 03:07
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Robert Haas 04:04
error occured in dbt2 against with postgresql Niu Yan 05:37
Re: Dynamlically updating the estimated cost of a transaction Greg Smith 05:43
Re: Load experimentation Ben Brehmer 07:22
Re: Load experimentation Greg Smith 07:35
Re: Load experimentation Scott Marlowe 07:58
Re: Load experimentation Scott Marlowe 07:59
Re: Load experimentation Dimitri Fontaine 09:08
Re: Load experimentation Scott Marlowe 09:28
Re: Load experimentation Dimitri Fontaine 09:37
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 09:41
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 09:59
Re: Checkpoint spikes Richard Neill 10:07
Re: Checkpoint spikes Richard Neill 10:08
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Thom Brown 10:11
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 10:18
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Andres Freund 10:28
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 10:42
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Craig Ringer 12:12
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 13:27
Optimizing Bitmap Heap Scan. niraj patel 13:38
Re: Optimizing Bitmap Heap Scan. Grzegorz Jaśkiewicz 13:42
Re: Optimizing Bitmap Heap Scan. niraj patel 13:50
Re: Optimizing Bitmap Heap Scan. Matthew Wakeling 14:03
Re: SSD + RAID Matthew Wakeling 14:22
Re: Optimizing Bitmap Heap Scan. niraj patel 14:27
Re: Optimizing Bitmap Heap Scan. Matthew Wakeling 14:48
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Robert Haas 15:02
Re: Checkpoint spikes Kevin Grittner 15:05
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Robert Haas 15:13
Re: Optimizing Bitmap Heap Scan. Lennin Caro 15:51
Vacuum running out of memory Jonathan Foy 15:51
Re: error occured in dbt2 against with postgresql Robert Haas 15:52
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Tom Lane 16:03
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Schmitz, David 16:07
Re: Vacuum running out of memory Tom Lane 16:22
Re: Vacuum running out of memory Jonathan Foy 16:31
Re: Vacuum running out of memory Greg Stark 16:41
Re: Vacuum running out of memory Tom Lane 16:42
Re: Optimizing Bitmap Heap Scan. Kevin Grittner 16:48
Re: performance penalty between Postgresql 8.3.8 and 8.4.1 Robert Haas 17:38
Re: Optimizing Bitmap Heap Scan. Robert Haas 18:30

Dec. 9, 2009

Thread Author Time
Re: Checkpoint spikes Greg Smith 02:05
Re: Checkpoint spikes Andres Freund 02:13
Re: Load experimentation Andy Colson 13:31
big select is resulting in a large amount of disk writing by kjournald Joseph S 18:29
Re: big select is resulting in a large amount of disk writing by kjournald Kenneth Marshall 19:45
Re: big select is resulting in a large amount of disk writing by kjournald Greg Smith 19:53
Re: big select is resulting in a large amount of disk writing by kjournald Joseph S 20:50
Re: big select is resulting in a large amount of disk writing by kjournald Greg Smith 22:04
Re: big select is resulting in a large amount of disk writing by kjournald Joseph S 22:24

Dec. 10, 2009

Thread Author Time
Fw: Help me put 2 Gigs of RAM to use Mark Stosberg 15:50
Re: Fw: Help me put 2 Gigs of RAM to use Matthew Wakeling 16:03
Re: big select is resulting in a large amount of disk writing by kjournald Kevin Grittner 16:41
Re: Help me put 2 Gigs of RAM to use Mark Stosberg 16:44
Re: Fw: Help me put 2 Gigs of RAM to use Greg Smith 16:45
Re: Fw: Help me put 2 Gigs of RAM to use Robert Haas 17:19
Re: Load experimentation Ben Brehmer 20:24
8.4.1 ubuntu karmic slow createdb Michael Clemmons 20:41
Re: 8.4.1 ubuntu karmic slow createdb Andres Freund 21:56
Re: 8.4.1 ubuntu karmic slow createdb Michael Clemmons 22:01
Re: 8.4.1 ubuntu karmic slow createdb Andres Freund 22:09
Re: Load experimentation Scott Carey 23:29

Dec. 11, 2009

Thread Author Time
Re: 8.4.1 ubuntu karmic slow createdb Nikolas Everett 01:38
Re: Load experimentation Scott Carey 02:37
Re: 8.4.1 ubuntu karmic slow createdb Joshua D. Drake 17:58
Re: 8.4.1 ubuntu karmic slow createdb Nikolas Everett 20:43
Re: 8.4.1 ubuntu karmic slow createdb Joshua D. Drake 20:50
Re: 8.4.1 ubuntu karmic slow createdb Nikolas Everett 21:39
Re: 8.4.1 ubuntu karmic slow createdb Scott Marlowe 21:57
Re: 8.4.1 ubuntu karmic slow createdb Scott Mead 21:59
Re: 8.4.1 ubuntu karmic slow createdb Scott Carey 22:12
Re: 8.4.1 ubuntu karmic slow createdb Scott Marlowe 22:12
Re: 8.4.1 ubuntu karmic slow createdb Scott Marlowe 22:19
Re: 8.4.1 ubuntu karmic slow createdb Greg Smith 22:39
Re: 8.4.1 ubuntu karmic slow createdb Michael Clemmons 22:52
Re: 8.4.1 ubuntu karmic slow createdb Scott Marlowe 23:59

Dec. 12, 2009

Thread Author Time
Re: 8.4.1 ubuntu karmic slow createdb Andres Freund 00:19
Re: 8.4.1 ubuntu karmic slow createdb Michael Clemmons 20:36
Re: 8.4.1 ubuntu karmic slow createdb Andres Freund 20:38

Dec. 13, 2009

Thread Author Time
Re: 8.4.1 ubuntu karmic slow createdb Robert Haas 03:56

Dec. 16, 2009

Thread Author Time
Re: big select is resulting in a large amount of disk writing by kjournald Scott Carey 01:28
Parallel Function calls using multiple processes Vishal Gupta 06:46
Re: Parallel Function calls using multiple processes Pavel Stehule 07:34
Re: Parallel Function calls using multiple processes Vishal Gupta 08:17
Re: Parallel Function calls using multiple processes Pavel Stehule 08:38

Dec. 17, 2009

Thread Author Time
Automatic optimization of IN clauses via INNER JOIN Thomas Hamilton 15:23
Re: Automatic optimization of IN clauses via INNER JOIN Tom Lane 15:32
Re: Automatic optimization of IN clauses via INNER JOIN Thomas Hamilton 15:45
Re: Automatic optimization of IN clauses via INNER JOIN Tom Lane 15:57
Re: Automatic optimization of IN clauses via INNER JOIN Robert Haas 18:05
Re: Automatic optimization of IN clauses via INNER JOIN Grzegorz Jaśkiewicz 20:05
seq scan instead of index scan Karl Larsson 23:22
Re: seq scan instead of index scan Scott Marlowe 23:26
Re: seq scan instead of index scan Kevin Grittner 23:29
Re: seq scan instead of index scan Karl Larsson 23:46

Dec. 18, 2009

Thread Author Time
Re: seq scan instead of index scan Greg Smith 00:10
Re: seq scan instead of index scan Scott Marlowe 00:11
Re: seq scan instead of index scan Karl Larsson 01:10
Re: seq scan instead of index scan Scott Marlowe 01:16
Re: seq scan instead of index scan Karl Larsson 01:17
Re: seq scan instead of index scan Scott Marlowe 01:37
Re: Automatic optimization of IN clauses via INNER JOIN Craig Ringer 02:20
Re: seq scan instead of index scan Tom Lane 06:27
Re: Issues with \copy from file Sigurgeir Gunnarsson 12:46
Re: Automatic optimization of IN clauses via INNER JOIN Robert Haas 14:18
Re: Automatic optimization of IN clauses via INNER JOIN Grzegorz Jaśkiewicz 14:24
Re: Issues with \copy from file Robert Haas 15:23
Re: Automatic optimization of IN clauses via INNER JOIN Robert Haas 15:23
Re: Automatic optimization of IN clauses via INNER JOIN Grzegorz Jaśkiewicz 15:24
Idea how to get rid of Bitmap Heap Scan Michael N. Mikhulya 15:44

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 23 24 25 26 27 28 29