Home > mailing lists

Mailing lists [pgsql-performance]

1 September 2008

01:49 Re: slow update of index during insert/copy Craig Ringer
08:14 Re: slow update of index during insert/copy Scott Carey
10:16 Re: slow update of index during insert/copy Thomas Finneid
10:29 Re: slow update of index during insert/copy Thomas Finneid
11:23 too many clog files Duan Ligong
12:31 limit clause breaks query planner? David West
12:53 Re: limit clause breaks query planner? Pavel Stehule
13:23 Re: Best hardware/cost tradoff? Fernando Hevia
14:35 Re: too many clog files Alvaro Herrera
14:44 Re: limit clause breaks query planner? David West
17:51 Re: slow update of index during insert/copy Scott Marlowe
18:47 Re: slow update of index during insert/copy Scott Carey
19:17 Re: limit clause breaks query planner? Pavel Stehule
19:42 Re: slow update of index during insert/copy Gregory Stark
20:33 Re: slow update of index during insert/copy Thomas Finneid
20:41 Re: slow update of index during insert/copy Scott Carey
20:42 Re: slow update of index during insert/copy Scott Marlowe
20:49 Re: slow update of index during insert/copy Scott Marlowe
21:03 Re: slow update of index during insert/copy Scott Carey

2 September 2008

00:56 Re: slow update of index during insert/copy Greg Smith
01:39 Re: too many clog files Duan Ligong
04:29 Re: limit clause breaks query planner? Russell Smith
05:32 Re: too many clog files Greg Smith
05:47 Re: too many clog files Tom Lane
06:39 Re: slow update of index during insert/copy Thomas Finneid
07:44 Re: limit clause breaks query planner? Guillaume Cottenceau
07:47 Re: limit clause breaks query planner? Pavel Stehule
07:57 Re: slow update of index during insert/copy Greg Smith
09:07 Re: limit clause breaks query planner? Guillaume Cottenceau
09:48 Re: limit clause breaks query planner? David West
09:53 Re: limit clause breaks query planner? Gregory Stark
10:16 Re: limit clause breaks query planner? Guillaume Cottenceau
11:16 Re: limit clause breaks query planner? David West
11:53 Re: limit clause breaks query planner? David West
12:29 Re: slow update of index during insert/copy Matthew Wakeling
13:55 Re: limit clause breaks query planner? Guillaume Cottenceau
14:09 Re: limit clause breaks query planner? David West
18:33 Re: too many clog files Guillaume Lelarge
18:44 Re: too many clog files Greg Smith
18:47 logging options... Jessica Richard
19:41 Re: logging options... Guillaume Lelarge
20:13 Re: limit clause breaks query planner? Matt Smiley
21:00 Re: limit clause breaks query planner? Tom Lane

3 September 2008

04:39 Re: Samsung 32GB SATA SSD tested behrangs
08:59 dblink /synonyms? Jan-Peter Seifert
10:00 Partitions number limitation ? s.caillet@free.fr
16:03 SAN and full_page_writes Nikolas Everett
16:44 Re: Partitions number limitation ? Scott Marlowe

4 September 2008

06:10 Re: limit clause breaks query planner? Matt Smiley
08:49 Re: slow update of index during insert/copy Thomas Finneid
15:32 Re: limit clause breaks query planner? Tom Lane
15:50 Re: limit clause breaks query planner? Matthew Wakeling
16:02 Re: Partitions number limitation ? Thomas Finneid
16:08 Re: limit clause breaks query planner? Guillaume Cottenceau
16:20 Re: limit clause breaks query planner? Matthew Wakeling
17:14 Re: limit clause breaks query planner? Tom Lane
18:04 Re: limit clause breaks query planner? Scott Carey
18:22 inaccurate stats on large tables Kiran Mukhyala
18:45 Re: limit clause breaks query planner? Matt Smiley
19:24 More shared_buffers instead of effective_cache_size? Ulrich
19:30 Re: More shared_buffers instead of effective_cache_size? Scott Marlowe
19:35 Re: slow update of index during insert/copy Greg Smith
19:39 Re: More shared_buffers instead of effective_cache_size? Ulrich
19:49 Re: More shared_buffers instead of effective_cache_size? Scott Marlowe
19:55 Re: limit clause breaks query planner? Gregory Stark
20:01 Re: More shared_buffers instead of effective_cache_size? Ulrich
20:48 Re: More shared_buffers instead of effective_cache_size? Scott Marlowe

5 September 2008

02:59 Re: too many clog files Duan Ligong
03:26 Re: inaccurate stats on large tables David Wilson
08:09 Re: slow update of index during insert/copy Thomas Finneid
11:49 Re: too many clog files Matthew Wakeling
12:13 You may need to increase mas_loks_per_trasaction Jonas Pacheco
12:38 Re: You may need to increase mas_loks_per_trasaction Claus Guttesen
14:24 Re: SAN and full_page_writes Nikolas Everett
15:10 Re: indexing for distinct search in timestamp based table Vladimir Sitnikov
16:25 Re: too many clog files Alvaro Herrera
16:39 Re: too many clog files Scott Marlowe
20:44 Re: You may need to increase mas_loks_per_trasaction Greg Smith

6 September 2008

19:46 Re: SAN and full_page_writes Bruce Momjian

7 September 2008

11:06 performance impact of non-C locale Axel Rau

8 September 2008

02:46 Re: too many clog files Duan Ligong
03:28 Re: too many clog files Duan Ligong
03:54 Re: indexing for distinct search in timestamp based table Rainer Mager
14:02 Re: SAN and full_page_writes Nikolas Everett
14:24 Re: SAN and full_page_writes Gregory Stark
14:48 Re: SAN and full_page_writes Nikolas Everett
14:59 Re: SAN and full_page_writes Gregory Stark
15:17 Re: SAN and full_page_writes Nikolas Everett
16:16 Re: inaccurate stats on large tables Matt Smiley
16:36 bitmap heap scan versus simple index and nested loop Scott Marlowe
22:35 Re: SAN and full_page_writes Bruce Momjian
23:12 Intel's X25-M SSD Greg Smith
23:59 Re: Intel's X25-M SSD Merlin Moncure

9 September 2008

00:34 Re: Intel's X25-M SSD Scott Carey
02:20 best use of another drive Rainer Mager
04:11 Re: best use of another drive Scott Marlowe
04:16 Re: best use of another drive Joshua Drake
04:35 Re: best use of another drive Rainer Mager
05:13 Re: best use of another drive Alex Hunsaker
08:07 Re: too many clog files Matt Smiley
14:08 How to measure IO performance? Andre Brandt
18:15 Re: How to measure IO performance? Scott Marlowe

10 September 2008

05:24 Re: too many clog files Matt Smiley
06:53 Effects of setting linux block device readahead size Mark Wong
10:32 Re: Intel's X25-M SSD Chris Browne
14:50 Re: Effects of setting linux block device readahead size Greg Smith
14:59 Re: too many clog files Kevin Grittner
16:32 Re: Effects of setting linux block device readahead size Scott Carey
16:48 Improve COPY performance for large data sets Ryan Hansen
17:14 Re: Improve COPY performance for large data sets Ryan Hansen
17:14 Re: Improve COPY performance for large data sets Alan Hodgson
17:16 Re: Improve COPY performance for large data sets Bill Moran
17:17 Re: Improve COPY performance for large data sets Dimitri Fontaine
17:18 Re: too many clog files Scott Marlowe
17:38 Re: Effects of setting linux block device readahead size Mark Wong
17:42 Re: too many clog files Tom Lane
17:48 Re: too many clog files Kevin Grittner
17:49 Re: Improve COPY performance for large data sets Scott Carey
17:57 Re: Improve COPY performance for large data sets Scott Carey
18:03 Re: too many clog files Scott Carey
18:04 Re: too many clog files Alvaro Herrera
18:11 Re: Effects of setting linux block device readahead size Scott Carey
19:45 Re: Effects of setting linux block device readahead size Greg Smith
20:55 Re: Improve COPY performance for large data sets Dimitri Fontaine
21:06 Re: Improve COPY performance for large data sets Scott Marlowe
21:44 Re: Effects of setting linux block device readahead size Scott Carey

11 September 2008

01:25 答复: [PERFORM] Improve COPY performance for large data sets jay
04:24 Re: Effects of setting linux block device readahead size Greg Smith
05:20 Re: Effects of setting linux block device readahead size James Mansion
05:47 Re: Effects of setting linux block device readahead size Scott Marlowe
05:56 Re: Effects of setting linux block device readahead size Greg Smith
09:29 Re: performance impact of non-C locale Peter Eisentraut
09:57 Re: performance impact of non-C locale Axel Rau
10:33 Re: performance impact of non-C locale Peter Eisentraut
16:45 Choosing a filesystem Laszlo Nagy
17:07 Re: Choosing a filesystem Andrew Sullivan
17:18 Re: Choosing a filesystem Matthew Wakeling
17:23 Re: Choosing a filesystem Kenneth Marshall
17:30 Re: Choosing a filesystem Kevin Grittner
17:49 Re: Choosing a filesystem Laszlo Nagy
18:26 Re: Choosing a filesystem Scott Marlowe
18:32 Re: Choosing a filesystem Scott Marlowe
19:15 Re: Effects of setting linux block device readahead size Scott Carey
19:53 Re: Effects of setting linux block device readahead size James Mansion
19:53 Re: Choosing a filesystem Craig James
20:11 Re: Choosing a filesystem Greg Smith
20: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
21:36 Re: Effects of setting linux block device readahead size david@lang.hm
21:40 Re: Effects of setting linux block device readahead size Scott Marlowe
22:33 Re: Effects of setting linux block device readahead size david@lang.hm
22:42 Re: Effects of setting linux block device readahead size Alan Hodgson
23:06 Re: Effects of setting linux block device readahead size david@lang.hm
23:20 Re: Effects of setting linux block device readahead size Scott Carey

12 September 2008

02:30 Re: Effects of setting linux block device readahead size Scott Marlowe
03:30 Re: [GENERAL] PostgreSQL TPC-H test result? Jignesh K. Shah
03:48 Re: [GENERAL] PostgreSQL TPC-H test result? Tom Lane
04:09 Re: Effects of setting linux block device readahead size Greg Smith
04:47 Re: [GENERAL] PostgreSQL TPC-H test result? Jonah H. Harris
07:45 Re: Choosing a filesystem Matthew Wakeling
08:38 Re: Choosing a filesystem Guillaume Cottenceau
09:02 Re: Choosing a filesystem Greg Smith
09:04 Re: Effects of setting linux block device readahead size James Mansion
09:12 Re: Choosing a filesystem Greg Smith
14:35 Re: Choosing a filesystem Merlin Moncure
14:48 Postgres Performance on CPU limited Platforms George McCollister
18:08 Re: Postgres Performance on CPU limited Platforms H. Hall

13 September 2008

21:21 Re: Effects of setting linux block device readahead size david@lang.hm
21:25 Re: Choosing a filesystem david@lang.hm

15 September 2008

02:49 Re: Choosing a filesystem Merlin Moncure
08:37 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Florian Weimer
14:11 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James
14:15 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Florian Weimer
14:26 Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James
16:18 Re: Effects of setting linux block device readahead size Matthew Wakeling
17:33 Re: Effects of setting linux block device readahead size Scott Carey

18 September 2008

05:07 Statement Timeout at User Level Gauri Kanekar
07:35 Re: Statement Timeout at User Level Albe Laurenz
13:22 Re: RAID arrays and performance Matthew Wakeling
17:30 Why does this query write to the disk? Nikolas Everett
17:50 Re: Why does this query write to the disk? Kevin Grittner
18:14 Re: Why does this query write to the disk? Tom Lane
18:30 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:44 Re: Why does this query write to the disk? Nikolas Everett
18:58 Re: Why does this query write to the disk? Tom Lane
19:30 Re: RAID arrays and performance Greg Smith
19:34 Re: RAID arrays and performance Scott Marlowe

19 September 2008

00:34 why does this use the wrong index? Rainer Mager
14:59 Re: RAID arrays and performance Matthew Wakeling
15:10 Re: RAID arrays and performance Tom Lane
15:26 Re: RAID arrays and performance Matthew Wakeling
16:23 Re: RAID arrays and performance Mark Mielke
18:25 Re: why does this use the wrong index? Jeff Davis
18:43 Re: why does this use the wrong index? Jeff Davis

20 September 2008

03:23 Re: Intel's X25-M SSD Greg Smith

22 September 2008

21:04 Re: Different execution plan Sabin Coanda
21:19 Re: Different execution plan Scott Marlowe

23 September 2008

04:47 Re: Intel's X25-M SSD Simon Riggs
17:02 Re: Choosing a filesystem Bruce Momjian
19:00 Re: Choosing a filesystem Simon Riggs
21:32 query planner and scanning methods Colin Copeland
22:07 Re: query planner and scanning methods Richard Broersma
22:25 Re: query planner and scanning methods Colin Copeland
22:57 Re: query planner and scanning methods Richard Broersma

24 September 2008

00:53 Chaotically weird execution plan Einars
01:13 Re: Chaotically weird execution plan Craig Ringer
02:58 Re: Chaotically weird execution plan Tom Lane
03:01 Re: Chaotically weird execution plan Tom Lane
03:12 Re: Chaotically weird execution plan Craig Ringer
03:25 Re: Intel's X25-M SSD Bruce Momjian
04:07 Re: Chaotically weird execution plan Scott Carey
04:25 Re: Intel's X25-M SSD Scott Carey
08:05 Re: Different execution plan Sabin Coanda
10:05 Re: Different execution plan Sabin Coanda
10:18 UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Laszlo Nagy
10:39 Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Claus Guttesen
10:52 Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Artis Caune
11:06 Re: Different execution plan Matthew Wakeling
11:12 Re: Intel's X25-M SSD Steve Clark
15:05 Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Axel Rau
19:22 Re: query planner and scanning methods Richard Broersma

25 September 2008

12:07 Slow index Matthew Wakeling
13:12 Re: Slow index Tom Lane
13:32 Re: Slow index Matthew Wakeling
19:25 Slow updates, poor IO John Huttley
19:35 Re: Slow updates, poor IO Scott Marlowe
19:39 Re: Slow updates, poor IO Alan Hodgson
19:42 CPU load kiki@fesb.hr
20:00 Re: CPU load Scott Marlowe
21:57 Re: Slow updates, poor IO Greg Smith

26 September 2008

06:43 Re: CPU load Albe Laurenz
11:28 Re: CPU load kiki@fesb.hr
12:52 Re: CPU load Albe Laurenz
13:16 Re: Slow updates, poor IO Andrew Sullivan
15:01 Re: CPU load Scott Carey
23:04 Re: Slow updates, poor IO John Huttley
23:09 Re: Slow updates, poor IO John Huttley

27 September 2008

07:04 Re: Slow updates, poor IO Greg Smith
15:09 Re: Slow updates, poor IO Scott Marlowe

28 September 2008

09:06 Re: Slow updates, poor IO Scott Marlowe
09:21 Re: Slow updates, poor IO John Huttley
14:33 Re: Slow updates, poor IO Tom Lane
16:24 Re: Slow updates, poor IO Scott Carey
21:53 Re: Slow updates, poor IO John Huttley
22:22 Re: Slow updates, poor IO John Huttley

29 September 2008

01:40 Re: Slow updates, poor IO Greg Smith
02:01 Re: Slow updates, poor IO John Huttley
02:15 Re: Slow updates, poor IO Scott Marlowe
03:09 Re: Slow updates, poor IO John Huttley
03:41 Re: Slow updates, poor IO Dan Langille
03:47 Re: Slow updates, poor IO John Huttley
04:12 Re: Slow updates, poor IO Scott Marlowe
07:17 Re: CPU load kiki@fesb.hr
07:26 Re: CPU load Harald Armin Massa
07:39 Re: CPU load Albe Laurenz
08:30 Re: CPU load kiki@fesb.hr
08:39 Re: CPU load kiki@fesb.hr
08:46 Re: CPU load hubert depesz lubaczewski
08:50 Re: CPU load Albe Laurenz
12:07 Re: CPU load Albe Laurenz
13:07 Re: CPU load kiki@fesb.hr
13:15 Re: CPU load Albe Laurenz
13:43 dedicated server & postgresql 8.1 conf tunning
16:00 Identical DB's, different execution plans Doug Eck
16:42 Re: Identical DB's, different execution plans Tom Lane
18:18 Re: Identical DB's, different execution plans Doug Eck
23:20 Re: Identical DB's, different execution plans Tom Lane

30 September 2008

00:17 Re: Identical DB's, different execution plans Doug Eck