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 - December 2009

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

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

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

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

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

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

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

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

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

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 diskwriting 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

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

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

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

Re: 8.4.1 ubuntu karmic slow createdb Robert Haas (03:56)

Dec. 16, 2009

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

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

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)

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

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