Home > mailing lists

Mailing lists [pgsql-performance]

1 January 2009

12:44 Re: Poor plan choice in prepared statement Robert Haas
17:23 Re: Poor plan choice in prepared statement Guillaume Smet
18:22 Re: Poor plan choice in prepared statement david@lang.hm
18:29 Re: Poor plan choice in prepared statement Guillaume Smet
18:38 Re: Poor plan choice in prepared statement david@lang.hm
19:24 Re: Poor plan choice in prepared statement Tom Lane

6 January 2009

02:16 bad selectivity estimates for CASE Robert Haas
03:40 Re: bad selectivity estimates for CASE Tom Lane
10:23 Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects Dmitry Koterov
11:25 Re: bad selectivity estimates for CASE Robert Haas
12:22 Re: bad selectivity estimates for CASE Tom Lane
15:51 understanding postgres issues/bottlenecks Stefano Nichele
16:16 Re: understanding postgres issues/bottlenecks Merlin Moncure
17:45 Re: understanding postgres issues/bottlenecks Scott Marlowe
17:59 Re: failure notice Scott Marlowe
18:03 Re: understanding postgres issues/bottlenecks Stefano Nichele
19:50 Re: understanding postgres issues/bottlenecks Scott Marlowe
22:33 Re: understanding postgres issues/bottlenecks David Rees

7 January 2009

01:20 Re: Memory Allocation (8 GB shared buffer limit on Ubuntu Hardy) Frank Joerdens
01:23 Re: Memory Allocation (8 GB shared buffer limit on Ubuntu Hardy) Tom Lane
02:46 Re: Memory Allocation (8 GB shared buffer limit on Ubuntu Hardy) Frank Joerdens
03:17 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
05:23 Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects Greg Smith
08:31 Re: understanding postgres issues/bottlenecks Simon Waters
11:48 Sl_log_1 and sl_log_2 not getting truncated. Nimesh Satam
12:58 Fwd: Casting issue!! jose fuenmayor
13:02 Re: Fwd: Casting issue!! Matthew Wakeling
13:32 Re: Fwd: Casting issue!! tv@fuzzy.cz
14:16 Re: Fwd: Casting issue!! Glyn Astill
14:35 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
14:41 Re: Sl_log_1 and sl_log_2 not getting truncated. Brad Nicholson
17:39 Are random writes optimized sequentially by Linux kernel? Dmitry Koterov
17:52 Re: Are random writes optimized sequentially by Linux kernel? david@lang.hm
18:06 Re: understanding postgres issues/bottlenecks Stefano Nichele
20:02 Re: understanding postgres issues/bottlenecks Stefano Nichele
20:34 Re: understanding postgres issues/bottlenecks Scott Marlowe
21:06 Re: understanding postgres issues/bottlenecks Scott Marlowe
21:32 Re: Are random writes optimized sequentially by Linux kernel? Dmitry Koterov
21:34 Re: understanding postgres issues/bottlenecks Greg Smith
21:41 Re: understanding postgres issues/bottlenecks Scott Marlowe
22:07 Re: Are random writes optimized sequentially by Linux kernel? david@lang.hm
22:28 Re: understanding postgres issues/bottlenecks Glyn Astill
22:35 Re: Are random writes optimized sequentially by Linux kernel? Greg Smith
22:36 Re: understanding postgres issues/bottlenecks Glyn Astill
22:43 Re: understanding postgres issues/bottlenecks Scott Marlowe
22:58 Re: understanding postgres issues/bottlenecks Bborie Park
23:11 Re: understanding postgres issues/bottlenecks Scott Carey

8 January 2009

00:19 Re: understanding postgres issues/bottlenecks Merlin Moncure
00:29 Re: understanding postgres issues/bottlenecks Scott Marlowe
01:36 Re: understanding postgres issues/bottlenecks Scott Carey
02:08 Re: Are random writes optimized sequentially by Linux kernel? M. Edward (Ed) Borasky
02:11 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
07:40 Re: understanding postgres issues/bottlenecks Stefano Nichele
11:52 Re: understanding postgres issues/bottlenecks Merlin Moncure
13:26 Re: understanding postgres issues/bottlenecks Glyn Astill
13:41 Re: understanding postgres issues/bottlenecks Stefano Nichele
13:42 Re: understanding postgres issues/bottlenecks Stefano Nichele
16:52 Re: understanding postgres issues/bottlenecks Scott Carey
19:28 Re: understanding postgres issues/bottlenecks Merlin Moncure

10 January 2009

11:40 Re: understanding postgres issues/bottlenecks Ron
11:53 Re: understanding postgres issues/bottlenecks Scott Marlowe
14:36 Re: understanding postgres issues/bottlenecks Gregory Stark
17:45 block device benchmarking Markus Wanner
17:46 Re: understanding postgres issues/bottlenecks david@lang.hm
18:01 Re: understanding postgres issues/bottlenecks Markus Wanner
18:11 Re: understanding postgres issues/bottlenecks Scott Marlowe
19:26 Re: understanding postgres issues/bottlenecks david@lang.hm
20:19 Re: understanding postgres issues/bottlenecks Gregory Stark
20:38 Re: understanding postgres issues/bottlenecks david@lang.hm
20:57 Re: understanding postgres issues/bottlenecks Ron
21:06 Re: understanding postgres issues/bottlenecks david@lang.hm
21:15 Re: understanding postgres issues/bottlenecks Gregory Stark
22:01 Re: understanding postgres issues/bottlenecks david@lang.hm
22:04 Re: understanding postgres issues/bottlenecks Luke Lonergan
22:10 Re: block device benchmarking M. Edward (Ed) Borasky
22:18 Re: understanding postgres issues/bottlenecks Luke Lonergan
22:44 Re: understanding postgres issues/bottlenecks Mark Kirkwood
23:52 Re: understanding postgres issues/bottlenecks david@lang.hm

11 January 2009

08:59 Re: understanding postgres issues/bottlenecks James Mansion
09:40 Re: block device benchmarking Markus Wanner
14:00 Re: understanding postgres issues/bottlenecks Stefano Nichele
14:10 Re: understanding postgres issues/bottlenecks Stefano Nichele
17:07 Re: understanding postgres issues/bottlenecks Scott Marlowe
17:13 Re: understanding postgres issues/bottlenecks Scott Marlowe
20:00 Re: understanding postgres issues/bottlenecks Glyn Astill
21:32 Re: understanding postgres issues/bottlenecks david@lang.hm
22:16 Re: understanding postgres issues/bottlenecks Luke Lonergan
22:28 Re: block device benchmarking M. Edward (Ed) Borasky
22:45 Re: understanding postgres issues/bottlenecks Scott Marlowe

12 January 2009

01:43 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
02:17 Re: understanding postgres issues/bottlenecks Robert Haas
03:28 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
03:38 Re: understanding postgres issues/bottlenecks Greg Smith
04:31 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
04:55 Re: understanding postgres issues/bottlenecks Mark Kirkwood
05:37 Re: understanding postgres issues/bottlenecks Scott Marlowe
09:08 Re: db server load Stefano Nichele
14:37 Re: understanding postgres issues/bottlenecks Matthew Wakeling
17:18 multicolumn indexes still efficient if not fully stressed? Jörg Kiegeland
17:59 Re: multicolumn indexes still efficient if not fullystressed? Mark Lewis
18:23 Re: multicolumn indexes still efficient if not fully stressed? Andreas Kretschmer
19:01 Re: multicolumn indexes still efficient if not fully stressed? Scott Marlowe
19:17 Re: multicolumn indexes still efficient if not fully stressed? Alan Hodgson
22:32 slow query Scott Marlowe
22:53 Re: slow query bricklen
22:53 Re: slow query Gregory Williamson
22:58 Re: slow query Gregory Stark
23:02 Re: slow query David Wilson
23:54 Re: slow query Scott Marlowe

13 January 2009

00:23 Slow insert performace, 8.3 Wal related? Bill Preston
00:38 Re: Slow insert performace, 8.3 Wal related? Tom Lane
00:47 Re: Slow insert performace, 8.3 Wal related? Alan Hodgson
04:42 Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
05:14 Re: Slow insert performace, 8.3 Wal related? Bill Preston
14:00 Re: understanding postgres issues/bottlenecks Jeff
14:40 Re: dbt-2 tuning results with postgresql-8.3.5 Kevin Grittner
15:10 Re: Slow insert performace, 8.3 Wal related? Alan Hodgson
21:37 strange index behaviour with different statistics target Jeff Frost
22:06 Re: strange index behaviour with different statistics target Tom Lane
22:26 Re: strange index behaviour with different statistics target Jeff Frost
22:40 Re: strange index behaviour with different statistics target Tom Lane
22:45 Re: strange index behaviour with different statistics target Jeff Frost

14 January 2009

02:49 Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
04:54 index Maksim Sosnovskiy
05:16 Re: index David Wilson
09:10 Re: Slow insert performace, 8.3 Wal related? Heikki Linnakangas
12:38 Re: index Euler Taveira de Oliveira

15 January 2009

09:42 row-specific conditions possible? Jörg Kiegeland
10:06 Re: row-specific conditions possible? A. Kretschmer
17:48 Cost of INSERT rules Enrico Weigelt
18:32 Re: understanding postgres issues/bottlenecks Jean-David Beyer
20:56 Re: Slow insert performace, 8.3 Wal related? Bill Preston
21:32 Re: Slow insert performace, 8.3 Wal related? Scott Marlowe
21:36 Re: Slow insert performace, 8.3 Wal related? Bill Preston

16 January 2009

05:03 Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky
06:57 Re: understanding postgres issues/bottlenecks david@lang.hm
18:50 Re: Slow insert performace, 8.3 Wal related? David Rees

19 January 2009

02:31 left join + case - how is it processed? Chris
03:17 Re: left join + case - how is it processed? Robert Haas
03:35 Re: left join + case - how is it processed? Evan Carroll
03:36 Re: left join + case - how is it processed? Chris
03:52 Re: left join + case - how is it processed? Evan Carroll
04:05 Re: left join + case - how is it processed? Chris
15:33 Re: left join + case - how is it processed? Tom Lane
15:51 Re: left join + case - how is it processed? Richard Broersma
16:40 test Akos Gabriel
17:07 Query running long - cost estimation question... Akos Gabriel
21:12 Re: left join + case - how is it processed? Chris

20 January 2009

15:07 Interesting query plan change linked to the LIMIT parameter Yannick Le Guédart
15:28 Re: Interesting query plan change linked to the LIMIT parameter David Wilson

21 January 2009

12:49 Re: Interesting query plan change linked to the LIMIT parameter Yannick Le Guédart
22:12 linux, memory (mis)accounting/reporting, and the planner/optimizer Dave Youatt
23:03 Re: linux, memory (mis)accounting/reporting, and the planner/optimizer Greg Smith

22 January 2009

05:23 Re: linux, memory (mis)accounting/reporting, and the planner/optimizer M. Edward (Ed) Borasky
05:48 caching indexes and pages? Thomas Finneid
06:01 Re: caching indexes and pages? A. Kretschmer
06:06 Re: caching indexes and pages? Thomas Markus
10:12 caching written values? Thomas Finneid
10:20 Re: caching written values? Pavan Deolasee
11:07 Re: caching written values? Glyn Astill
11:11 Re: caching written values? Thomas Finneid
11:35 Re: caching written values? Thomas Finneid
14:34 Re: caching indexes and pages? Robert Haas
14:36 Re: caching written values? Robert Haas
14:41 Slow HashAggregate : How to optimize ? Bruno Baguette
14:47 postgresql 8.3 tps rate Ibrahim Harrani
15:50 Re: Slow HashAggregate : How to optimize ? Robert Haas
15:56 Re: postgresql 8.3 tps rate Claus Guttesen
15:56 Re: postgresql 8.3 tps rate Joshua D. Drake
16:03 Re: linux, memory (mis)accounting/reporting, and the planner/optimizer Greg Smith
16:14 Re: postgresql 8.3 tps rate Merlin Moncure
17:03 Re: caching written values? Simon Riggs
17:38 Re: linux, memory (mis)accounting/reporting, and the planner/optimizer M. Edward (Ed) Borasky
18:00 Re: postgresql 8.3 tps rate Alvaro Herrera
18:52 Question about clustering indexes and restores Harold A. Giménez Ch.
18:58 Re: Question about clustering indexes and restores Kenneth Marshall
19:02 Re: Question about clustering indexes and restores Harold A. Giménez Ch.
20:27 Re: postgresql 8.3 tps rate Ibrahim Harrani
20:36 Re: postgresql 8.3 tps rate Ibrahim Harrani
20:41 Re: postgresql 8.3 tps rate David Rees
20:58 Re: caching indexes and pages? Thomas Finneid
21:03 Re: caching indexes and pages? Kenneth Marshall
21:30 Re: postgresql 8.3 tps rate Ibrahim Harrani
23:28 Re: postgresql 8.3 tps rate Scott Marlowe
23:37 Re: postgresql 8.3 tps rate Craig James

23 January 2009

00:44 Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
02:45 Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith
02:52 Re: postgresql 8.3 tps rate Greg Smith
04:52 Re: caching indexes and pages? Craig Ringer
04:52 Re: postgresql 8.3 tps rate Ibrahim Harrani
05:10 Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
05:35 Re: postgresql 8.3 tps rate Craig James
07:43 Re: postgresql 8.3 tps rate Scott Marlowe
09:33 SSD performance david@lang.hm
10:12 Re: SSD performance Glyn Astill
10:35 Re: SSD performance david@lang.hm
10:42 Re: SSD performance Luke Lonergan
10:49 Re: SSD performance david@lang.hm
10:53 Re: SSD performance Matthew Wakeling
10:53 Re: SSD performance Luke Lonergan
12:50 Re: SSD performance Craig Ringer
13:37 Re: SSD performance Florian Weimer
13:51 Re: postgresql 8.3 tps rate Merlin Moncure
13:59 Re: SSD performance Merlin Moncure
14:56 More Troubles Dumping a Very Large Table Ted Allen
16:15 Re: SSD performance david@lang.hm
16:21 Re: SSD performance M. Edward (Ed) Borasky
16:30 Re: SSD performance Joshua D. Drake
16:39 Re: SSD performance Matthew Wakeling
21:59 Re: postgresql 8.3 tps rate Greg Smith

24 January 2009

02:23 Re: SSD performance M. Edward (Ed) Borasky
06:02 "tablespace" for tranaction log? Thomas Finneid
09:57 strange index performance? Thomas Finneid
13:57 Re: strange index performance? Scott Marlowe
18:33 Re: strange index performance? Scott Marlowe
21:20 Re: "tablespace" for tranaction log? Euler Taveira de Oliveira

25 January 2009

06:27 Re: SSD performance Greg Smith
06:32 Re: SSD performance david@lang.hm
06:45 Re: strange index performance? Thomas Finneid
07:14 Re: strange index performance? Thomas Finneid
08:58 Re: strange index performance? Scott Marlowe
10:55 Re: SSD performance Gregory Stark
11:13 Re: SSD performance david@lang.hm
15:22 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
16:04 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
19:45 Re: postgresql 8.3 tps rate Greg Smith
20:21 [PERFORMANCE] Buying hardware A B
20:42 Re: [PERFORMANCE] Buying hardware Scott Marlowe
21:21 Re: strange index performance? Thomas Finneid
21:24 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
21:28 Re: strange index performance? Scott Marlowe

26 January 2009

08:10 Re: strange index performance? Thomas Finneid
11:10 Re: [PERFORMANCE] Buying hardware Matthew Wakeling
11:18 Re: postgresql 8.3 tps rate Matthew Wakeling
12:51 Re: strange index performance? Kenneth Marshall
13:49 Re: strange index performance? Thomas Finneid
14:37 Re: strange index performance? Kenneth Marshall
15:09 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
17:09 Re: postgresql 8.3 tps rate Craig Ringer
18:12 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
18:29 Re: postgresql 8.3 tps rate Greg Smith
18:46 Re: [PERFORMANCE] Buying hardware David Rees
18:58 Re: [PERFORMANCE] Buying hardware Jeff
19:01 Re: [PERFORMANCE] Buying hardware Joshua D. Drake
19:04 Re: [PERFORMANCE] Buying hardware Kenny Gorman
19:12 Re: [PERFORMANCE] Buying hardware David Rees
19:27 Re: [PERFORMANCE] Buying hardware Jeff
19:56 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky
20:07 Re: [PERFORMANCE] Buying hardware David Rees
20:48 Re: postgresql 8.3 tps rate Ron Mayer
20:55 Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky

27 January 2009

00:07 Re: [PERFORMANCE] Buying hardware Craig Ringer
01:56 Re: [PERFORMANCE] Buying hardware david@lang.hm
02:03 Re: [PERFORMANCE] Buying hardware david@lang.hm
05:47 Re: SSD performance James Mansion
05:48 Re: SSD performance david@lang.hm
05:53 Odd behavior with temp usage logging Josh Berkus
07:14 Re: Odd behavior with temp usage logging Craig Ringer
07:20 Re: [PERFORMANCE] Buying hardware A B
12:28 Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky
13:02 Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky
13:38 Re: [PERFORMANCE] Buying hardware david@lang.hm
14:19 Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky
16:34 Re: Odd behavior with temp usage logging Josh Berkus
23:06 LIKE Query performance Hari, Balaji

28 January 2009

05:27 Re: LIKE Query performance Oleg Bartunov
08:15 Need help in setting up DBT2 for PostgreSQL Rohan Pethkar
08:27 Re: LIKE Query performance Marcin Stępnicki
08:43 Re: LIKE Query performance A. Kretschmer
12:33 PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Phoenix Kiula
13:09 Re: LIKE Query performance Robert Haas
13:19 Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Robert Haas
13:26 Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Richard Huxton
16:55 Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Merlin Moncure
19:02 Re: [PERFORMANCE] Buying hardware Scott Marlowe
19:03 Re: [PERFORMANCE] Buying hardware Scott Marlowe

29 January 2009

06:06 NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster
06:37 Re: NOT IN >2hrs vs EXCEPT < 2 sec. Scott Marlowe
07:01 Re: NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster
07:02 Re: NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster
12:00 Re: NOT IN >2hrs vs EXCEPT < 2 sec. Gregory Stark
13:56 Re: NOT IN >2hrs vs EXCEPT < 2 sec. Tom Lane
15:04 Max on union
16:12 Re: LIKE Query performance Hari, Balaji
17:05 Re: LIKE Query performance Hari, Balaji
18:06 Re: LIKE Query performance Oleg Bartunov
19:10 Re: Max on union Robert Haas
19:21 Using multiple cores for index creation? henk de wit
19:22 Sort performance Subbiah Stalin-XCGF84
20:13 Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Chris Browne
22:09 Re: Using multiple cores for index creation? Robert Haas
22:19 Re: Using multiple cores for index creation? Joshua D. Drake
22:21 Re: Sort performance Robert Haas
22:35 Re: Sort performance Gregory Stark
22:36 Re: Sort performance Subbiah Stalin-XCGF84
22:58 Re: Sort performance Subbiah Stalin-XCGF84
23:03 Re: Using multiple cores for index creation? henk de wit

30 January 2009

00:25 Re: Using multiple cores for index creation? Tom Lane
06:53 Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Scott Marlowe
18:41 Re: Poor plan choice in prepared statement Scott Carey
19:04 Re: Using multiple cores for index creation? Scott Carey

31 January 2009

02:29 Re: SSD performance Scott Carey