Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2008-09 Chronological Index (1/2)
Last updated: Wed Jan 18 04:15:35 2012
268 messages
29 September 2008
Re: Identical DB's, different execution plans Doug Eck (18:18)
Re: Identical DB's, different execution plans Tom Lane (16:42)
Identical DB's, different execution plans Doug Eck (16:00)
dedicated server & postgresql 8.1 conf tunning paul (13:43)
Re: CPU load Albe Laurenz (13:15)
Re: CPU load kiki (13:07)
Re: CPU load Albe Laurenz (12:06)
Re: CPU load Albe Laurenz (08:50)
Re: CPU load hubert depesz lubaczewski (08:46)
Re: CPU load kiki (08:39)
Re: CPU load kiki (08:30)
Re: CPU load Albe Laurenz (07:39)
Re: CPU load Harald Armin Massa (07:26)
Re: CPU load kiki (07:17)
Re: Slow updates, poor IO Scott Marlowe (04:12)
Re: Slow updates, poor IO John Huttley (03:47)
Re: Slow updates, poor IO Dan Langille (03:41)
Re: Slow updates, poor IO John Huttley (03:09)
Re: Slow updates, poor IO Scott Marlowe (02:15)
Re: Slow updates, poor IO John Huttley (02:01)
Re: Slow updates, poor IO Greg Smith (01:40)
28 September 2008
Re: Slow updates, poor IO John Huttley (21:53)
Re: Slow updates, poor IO Scott Carey (16:24)
Re: Slow updates, poor IO Tom Lane (14:33)
Re: Slow updates, poor IO John Huttley (09:21)
Re: Slow updates, poor IO Scott Marlowe (09:06)
27 September 2008
Re: Slow updates, poor IO Greg Smith (07:04)
26 September 2008
Re: Slow updates, poor IO John Huttley (23:04)
Re: CPU load Scott Carey (15:01)
Re: Slow updates, poor IO Andrew Sullivan (13:16)
Re: CPU load Albe Laurenz (12:52)
Re: CPU load kiki (11:28)
Re: CPU load Albe Laurenz (06:43)
25 September 2008
Re: CPU load Scott Marlowe (20:00)
CPU load kiki (19:42)
Re: Slow updates, poor IO Alan Hodgson (19:39)
Re: Slow updates, poor IO Scott Marlowe (19:35)
Slow updates, poor IO John Huttley (19:25)
Re: Slow index Matthew Wakeling (13:32)
Re: Slow index Tom Lane (13:12)
Slow index Matthew Wakeling (12:07)
24 September 2008
Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Axel Rau (15:05)
Re: Intel's X25-M SSD Steve Clark (11:12)
Re: Different execution plan Matthew Wakeling (11:06)
Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Artis Caune (10:52)
Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Claus Guttesen (10:39)
UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Laszlo Nagy (10:18)
Re: Different execution plan Sabin Coanda (10:05)
Re: Different execution plan Sabin Coanda (08:05)
Re: Intel's X25-M SSD Scott Carey (04:25)
Re: Chaotically weird execution plan Scott Carey (04:07)
Re: Intel's X25-M SSD Bruce Momjian (03:24)
Re: Chaotically weird execution plan Craig Ringer (03:12)
Re: Chaotically weird execution plan Tom Lane (03:01)
Re: Chaotically weird execution plan Tom Lane (02:58)
Re: Chaotically weird execution plan Craig Ringer (01:13)
Chaotically weird execution plan Einars (00:53)
23 September 2008
Re: query planner and scanning methods Colin Copeland (22:25)
Re: query planner and scanning methods Richard Broersma (22:07)
query planner and scanning methods Colin Copeland (21:32)
Re: Choosing a filesystem Simon Riggs (19:00)
Re: Choosing a filesystem Bruce Momjian (17:02)
Re: Intel's X25-M SSD Simon Riggs (04:47)
22 September 2008
Re: Different execution plan Sabin Coanda (21:04)
20 September 2008
19 September 2008
Re: why does this use the wrong index? Jeff Davis (18:25)
Re: RAID arrays and performance Mark Mielke (16:23)
Re: RAID arrays and performance Matthew Wakeling (15:26)
Re: RAID arrays and performance Tom Lane (15:10)
Re: RAID arrays and performance Matthew Wakeling (14:59)
why does this use the wrong index? Rainer Mager (00:34)
18 September 2008
Re: RAID arrays and performance Greg Smith (19:30)
Re: Why does this query write to the disk? Tom Lane (18:58)
Re: Why does this query write to the disk? Nikolas Everett (18:44)
Re: Why does this query write to the disk? Scott Carey (18:33)
Re: Why does this query write to the disk? Scott Carey (18:30)
Re: Why does this query write to the disk? Tom Lane (18:14)
Re: Why does this query write to the disk? Kevin Grittner (17:50)
Why does this query write to the disk? Nikolas Everett (17:30)
Re: RAID arrays and performance Matthew Wakeling (13:22)
Re: Statement Timeout at User Level Albe Laurenz (07:35)
Statement Timeout at User Level Gauri Kanekar (05:07)
15 September 2008
Re: Effects of setting linux block device readahead size Matthew Wakeling (16:18)
Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (14:26)
Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Florian Weimer (14:15)
Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (14:11)
Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Florian Weimer (08:37)
Re: Choosing a filesystem Merlin Moncure (02:49)
13 September 2008
Re: Effects of setting linux block device readahead size david (21:21)
12 September 2008
Postgres Performance on CPU limited Platforms George McCollister (14:48)
Re: Choosing a filesystem Merlin Moncure (14:35)
Re: Choosing a filesystem Greg Smith (09:12)
Re: Effects of setting linux block device readahead size James Mansion (09:04)
Re: Choosing a filesystem Greg Smith (09:01)
Re: Choosing a filesystem Guillaume Cottenceau (08:38)
Re: Choosing a filesystem Matthew Wakeling (07:45)
Re: [GENERAL] PostgreSQL TPC-H test result? Jonah H. Harris (04:47)
Re: Effects of setting linux block device readahead size Greg Smith (04:09)
Re: [GENERAL] PostgreSQL TPC-H test result? Tom Lane (03:48)
Re: [GENERAL] PostgreSQL TPC-H test result? Jignesh K. Shah (03:30)
Re: Effects of setting linux block device readahead size Scott Marlowe (02:30)
11 September 2008
Re: Effects of setting linux block device readahead size david (23:06)
Re: Effects of setting linux block device readahead size Alan Hodgson (22:42)
Re: Effects of setting linux block device readahead size david (22:33)
Re: Effects of setting linux block device readahead size Scott Marlowe (21:40)
Re: Effects of setting linux block device readahead size david (21:36)
Re: Effects of setting linux block device readahead size Scott Carey (20:44)
Re: Effects of setting linux block device readahead size Scott Carey (20:36)
Re: Choosing a filesystem Greg Smith (20:11)
Re: Choosing a filesystem Craig James (19:53)
Re: Effects of setting linux block device readahead size James Mansion (19:53)
Re: Effects of setting linux block device readahead size Scott Carey (19:15)
Re: Choosing a filesystem Scott Marlowe (18:32)
Re: Choosing a filesystem Scott Marlowe (18:26)
Re: Choosing a filesystem Laszlo Nagy (17:49)
Re: Choosing a filesystem Kevin Grittner (17:30)
Re: Choosing a filesystem Kenneth Marshall (17:23)
Re: Choosing a filesystem Matthew Wakeling (17:18)
Re: Choosing a filesystem Andrew Sullivan (17:07)
Choosing a filesystem Laszlo Nagy (16:45)
Re: performance impact of non-C locale Peter Eisentraut (10:33)
Re: performance impact of non-C locale Axel Rau (09:57)
Re: performance impact of non-C locale Peter Eisentraut (09:29)
Re: Effects of setting linux block device readahead size Greg Smith (05:56)
Re: Effects of setting linux block device readahead size Scott Marlowe (05:47)
Re: Effects of setting linux block device readahead size James Mansion (05:20)
Re: Effects of setting linux block device readahead size Greg Smith (04:24)
答复: [PERFORM] Improve COPY performance for large data sets jay (01:25)
10 September 2008
Re: Improve COPY performance for large data sets Scott Marlowe (21:06)
Re: Improve COPY performance for large data sets Dimitri Fontaine (20:55)
Re: Effects of setting linux block device readahead size Greg Smith (19:45)
Re: Effects of setting linux block device readahead size Scott Carey (18:11)
Re: too many clog files Alvaro Herrera (18:04)
Re: too many clog files Scott Carey (18:03)
Re: Improve COPY performance for large data sets Scott Carey (17:57)
Re: Improve COPY performance for large data sets Scott Carey (17:49)
Re: too many clog files Kevin Grittner (17:48)
Re: too many clog files Tom Lane (17:42)
Re: Effects of setting linux block device readahead size Mark Wong (17:38)
Re: too many clog files Scott Marlowe (17:18)
Re: Improve COPY performance for large data sets Dimitri Fontaine (17:17)
Re: Improve COPY performance for large data sets Bill Moran (17:16)
Re: Improve COPY performance for large data sets Alan Hodgson (17:14)
Re: Improve COPY performance for large data sets Ryan Hansen (17:14)
Improve COPY performance for large data sets Ryan Hansen (16:48)
Re: Effects of setting linux block device readahead size Scott Carey (16:32)
Re: too many clog files Kevin Grittner (14:59)
Re: Effects of setting linux block device readahead size Greg Smith (14:49)
Re: Intel's X25-M SSD Chris Browne (10:32)
Effects of setting linux block device readahead size Mark Wong (06:53)
Re: too many clog files Matt Smiley (05:24)
09 September 2008
How to measure IO performance? Andre Brandt (14:08)
Re: too many clog files Matt Smiley (08:07)
Re: best use of another drive Alex Hunsaker (05:13)
Re: best use of another drive Rainer Mager (04:35)
Re: best use of another drive Joshua Drake (04:16)
Re: best use of another drive Scott Marlowe (04:11)
best use of another drive Rainer Mager (02:20)
Re: Intel's X25-M SSD Scott Carey (00:34)
08 September 2008
Intel's X25-M SSD Greg Smith (23:12)
Re: SAN and full_page_writes Bruce Momjian (22:35)
bitmap heap scan versus simple index and nested loop Scott Marlowe (16:36)