Home > mailing lists

Mailing lists [pgsql-performance]

1 January 2010

10:54 Message queue table - strange performance drop with changing limit size. Jesper Krogh
13:54 Re: Message queue table - strange performance drop with changing limit size. Greg Williamson
14:05 Re: Message queue table - strange performance drop with changing limit size. Jesper Krogh

2 January 2010

11:25 Re: Message queue table - strange performance drop with changing limit size. Dimitri Fontaine

3 January 2010

18:21 Re: Message queue table - strange performance drop with changing limit size. Greg Smith

4 January 2010

18:16 DB is slow until DB is reloaded Madison Kelly
18:35 Re: DB is slow until DB is reloaded Gary Doades
18:48 Re: DB is slow until DB is reloaded Steve Crawford
18:54 query looping? Brian Cox
19:30 Re: DB is slow until DB is reloaded Madison Kelly
19:39 Re: DB is slow until DB is reloaded Richard Neill
19:40 Re: DB is slow until DB is reloaded Gary Doades
19:54 Re: DB is slow until DB is reloaded Madison Kelly
20:01 Re: DB is slow until DB is reloaded Brad Nicholson
20:04 Re: DB is slow until DB is reloaded Kevin Grittner
20:32 Re: DB is slow until DB is reloaded Madison Kelly
20:33 Re: DB is slow until DB is reloaded Madison Kelly
20:43 Re: DB is slow until DB is reloaded Steve Crawford
20:47 forced sequential scan when condition has current_user Keresztury Balázs
20:53 Re: query looping? Robert Haas
20:53 Re: DB is slow until DB is reloaded Steve Crawford
20:54 Re: DB is slow until DB is reloaded Madison Kelly
20:57 Re: DB is slow until DB is reloaded Madison Kelly
20:59 Re: forced sequential scan when condition has current_user Robert Haas
21:06 Re: DB is slow until DB is reloaded Rosser Schwarz
21:14 Re: DB is slow until DB is reloaded Greg Smith
21:26 Re: query looping? Brian Cox
21:49 Re: forced sequential scan when condition has current_user Keresztury Balázs
21:51 Re: DB is slow until DB is reloaded Scott Marlowe
22:21 Re: forced sequential scan when condition has current_user Erik Jones
23:35 Re: DB is slow until DB is reloaded Madison Kelly
23:36 Re: DB is slow until DB is reloaded Madison Kelly

5 January 2010

00:13 Re: DB is slow until DB is reloaded Steve Crawford
01:09 Re: forced sequential scan when condition has current_user Robert Haas
01:13 pg_connect takes 3.0 seconds Dmitri Girski
01:14 Re: forced sequential scan when condition has current_user Craig Ringer
02:03 Re: pg_connect takes 3.0 seconds Greg Smith
03:32 Re: DB is slow until DB is reloaded Craig James
04:14 Re: pg_connect takes 3.0 seconds Tom Lane
04:16 Re: forced sequential scan when condition has current_user Tom Lane
12:17 Re: DB is slow until DB is reloaded Brad Nicholson
13:14 Re: forced sequential scan when condition has current_user Fernando Hevia
14:03 Re: pg_connect takes 3.0 seconds Andy Colson
14:03 Re: query looping? Robert Haas
16:38 Re: forced sequential scan when condition has current_user Keresztury Balázs
20:07 Re: query looping? Brian Cox
20:34 Re: query looping? Brian Cox
21:33 Re: pg_connect takes 3.0 seconds Scott Carey

6 January 2010

00:05 Re: DB is slow until DB is reloaded Scott Carey
00:18 Re: DB is slow until DB is reloaded Craig Ringer
00:34 Re: query looping? Robert Haas
02:25 Re: pg_connect takes 3.0 seconds Dmitri Girski
02:28 Re: pg_connect takes 3.0 seconds Dmitri Girski
02:30 Re: pg_connect takes 3.0 seconds Dmitri Girski
02:50 Re: pg_connect takes 3.0 seconds Dmitri Girski
03:27 Re: pg_connect takes 3.0 seconds Dmitri Girski
03:39 Re: pg_connect takes 3.0 seconds Scott Marlowe
03:51 Re: pg_connect takes 3.0 seconds Craig Ringer
09:45 Re: pg_connect takes 3.0 seconds Matthew Wakeling
16:45 Re: pg_connect takes 3.0 seconds Robert Haas
16:51 Re: pg_connect takes 3.0 seconds Dave Crooke
18:11 Re: pg_connect takes 3.0 seconds Craig James
18:22 Digesting explain analyze Jesper Krogh
19:03 Re: Digesting explain analyze Ron Mayer
22:54 noob inheritance question Zintrigue
23:00 Re: noob inheritance question Richard Broersma
23:13 Re: noob inheritance question Richard Neill

7 January 2010

00:58 Re: Digesting explain analyze Robert Haas
01:44 Re: pg_connect takes 3.0 seconds Dmitri Girski
02:35 Re: pg_connect takes 3.0 seconds Scott Marlowe
03:01 Re: noob inheritance question Nikolas Everett
03:22 Joining on text field VS int Radhika S
05:11 Re: Digesting explain analyze Jesper Krogh
05:39 Re: Digesting explain analyze Greg Smith
06:40 Re: pg_connect takes 3.0 seconds Craig Ringer
06:44 Massive table (500M rows) update nightmare Carlo Stonebanks
06:49 Re: Optimizer use of index slows down query by factor Michael Ruf
06:49 Re: Massive table (500M rows) update nightmare Scott Marlowe
07:25 Re: Digesting explain analyze Oleg Bartunov
10:24 Re: Digesting explain analyze Matthew Wakeling
11:41 Air-traffic benchmark Lefteris
12:33 Re: Air-traffic benchmark Gurgel, Flavio
12:35 Re: Air-traffic benchmark A. Kretschmer
12:39 Re: Massive table (500M rows) update nightmare Leo Mannhart
12:42 Re: Air-traffic benchmark Lefteris
12:44 Re: Air-traffic benchmark Arjen van der Meijden
12:48 Re: Air-traffic benchmark Lefteris
12:59 Re: Air-traffic benchmark A. Kretschmer
13:02 Re: Air-traffic benchmark A. Kretschmer
13:10 Re: Air-traffic benchmark Lefteris
13:14 Re: Air-traffic benchmark Alvaro Herrera
13:16 Re: Air-traffic benchmark Alvaro Herrera
13:23 Re: Air-traffic benchmark Lefteris
13:29 Re: Air-traffic benchmark Jochen Erwied
13:52 Re: Air-traffic benchmark Ivan Voras
14:05 Re: Air-traffic benchmark Lefteris
14:16 Re: Air-traffic benchmark Grzegorz Jaśkiewicz
14:19 Re: Massive table (500M rows) update nightmare Kevin Grittner
14:45 Re: Air-traffic benchmark Gurgel, Flavio
14:47 Re: Massive table (500M rows) update nightmare Leo Mannhart
14:54 "large" spam tables and performance: postgres memory parameters Gary Warner
14:57 Re: Air-traffic benchmark Ivan Voras
15:04 Re: Air-traffic benchmark Lefteris
15:24 Re: Air-traffic benchmark Matthew Wakeling
15:34 Re: Air-traffic benchmark Craig James
15:38 Re: Massive table (500M rows) update nightmare Ludwik Dylag
15:58 Re: Massive table (500M rows) update nightmare Kevin Grittner
16:36 Re: "large" spam tables and performance: postgres memory parameters Kevin Grittner
16:46 Re: Massive table (500M rows) update nightmare Kevin Kempter
16:56 Re: Massive table (500M rows) update nightmare Greg Sabino Mullane
16:57 Re: Air-traffic benchmark Gurgel, Flavio
17:02 Re: Air-traffic benchmark Scott Marlowe
17:10 Re: Air-traffic benchmark Gurgel, Flavio
17:11 Re: Air-traffic benchmark Nikolas Everett
17:14 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
17:14 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
17:45 Re: query looping? Brian Cox
17:53 Re: Joining on text field VS int Nikolas Everett
19:13 Re: pg_connect takes 3.0 seconds Dave Crooke
19:16 Re: query looping? Robert Haas
19:20 Re: noob inheritance question Robert Haas
20:05 Re: Massive table (500M rows) update nightmare marcin mank
21:14 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
21:22 Re: Air-traffic benchmark Greg Smith
21:57 Re: Air-traffic benchmark Lefteris
22:09 Re: Air-traffic benchmark Lefteris
22:39 Re: Air-traffic benchmark hubert depesz lubaczewski
23:18 Re: Massive table (500M rows) update nightmare Kevin Grittner
23:39 Re: Air-traffic benchmark Greg Smith

8 January 2010

00:40 Re: Massive table (500M rows) update nightmare Scott Marlowe
00:59 Re: "large" spam tables and performance: postgres memory parameters Scott Marlowe
01:03 Re: "large" spam tables and performance: postgres memory parameters Stephen Frost
02:31 Re: Air-traffic benchmark Craig Ringer
02:43 Re: Air-traffic benchmark Tom Lane
02:45 Re: Air-traffic benchmark Craig Ringer
04:07 Array comparison ramasubramanian
05:14 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
05:14 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
05:22 Re: Massive table (500M rows) update nightmare Scott Marlowe
10:04 FusionIO performance Tore Halvorsen
10:19 Re: Massive table (500M rows) update nightmare Eduardo Morras
13:11 Re: Massive table (500M rows) update nightmare Kevin Grittner
15:06 Re: Array comparison Rui Carvalho
15:36 Re: Array comparison Merlin Moncure
16:15 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
16:22 Re: Massive table (500M rows) update nightmare Andreas Kretschmer
16:44 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
17:08 Re: Massive table (500M rows) update nightmare Kenneth Marshall
17:08 Change query join order Kaloyan Iliev Iliev
17:12 Re: Massive table (500M rows) update nightmare Greg Smith
17:13 Re: Massive table (500M rows) update nightmare Kevin Grittner
17:27 Re: Change query join order Tom Lane
18:01 Re: Change query join order Robert Haas
18:24 Re: Change query join order Tom Lane
18:55 Re: Change query join order Robert Haas

9 January 2010

07:21 Re: Massive table (500M rows) update nightmare Pierre Frédéric Caillaud
09:32 PG optimization question Nickolay
09:37 PG optimization question Nickolay
11:18 Re: PG optimization question Grzegorz Jaśkiewicz
11:33 Re: PG optimization question Thomas Kellerer
11:42 Re: PG optimization question Nickolay
11:46 Joint index including MAX() ? Richard Neill
11:46 Re: PG optimization question Kenneth Marshall
11:51 Re: Joint index including MAX() ? Grzegorz Jaśkiewicz
11:52 Re: Joint index including MAX() ? Lefteris
11:59 Re: PG optimization question Nickolay
14:37 Re: PG optimization question Pierre Frédéric Caillaud
15:37 Re: pg_connect takes 3.0 seconds Dmitri Girski
16:07 Re: Joint index including MAX() ? Tom Lane
17:50 Re: PG optimization question Nickolay
17:58 Re: PG optimization question Ludwik Dylag

10 January 2010

00:24 Re: PG optimization question Craig Ringer
09:51 Re: PG optimization question Pierre Frédéric Caillaud
11:28 Choice of bitmap scan over index scan Mathieu De Zutter
13:05 Re: Choice of bitmap scan over index scan Jeremy Harris
14:19 Re: Choice of bitmap scan over index scan Kevin Grittner
14:43 Re: Choice of bitmap scan over index scan Mathieu De Zutter
14:54 Re: Choice of bitmap scan over index scan Kevin Grittner
15:01 Re: Choice of bitmap scan over index scan Kevin Grittner
17:45 Re: PG optimization question Robert Haas

11 January 2010

01:52 Re: Choice of bitmap scan over index scan Robert Haas
01:53 Re: Choice of bitmap scan over index scan Robert Haas
07:36 Re: Choice of bitmap scan over index scan Mathieu De Zutter
09:37 Re: Choice of bitmap scan over index scan Matthew Wakeling
10:23 Re: Choice of bitmap scan over index scan Pierre Frédéric Caillaud
10:25 Re: PG optimization question Pierre Frédéric Caillaud
12:44 performance config help Bob Dusek
12:51 Re: performance config help Scott Marlowe
13:08 Re: performance config help A. Kretschmer
14:11 Re: Choice of bitmap scan over index scan Kevin Grittner
15:42 Re: performance config help Bob Dusek
16:11 Re: performance config help Bob Dusek
16:13 Re: performance config help Ivan Voras
16:18 Re: performance config help Kevin Grittner
16:20 Re: performance config help Ivan Voras
16:24 cache false-sharing in lwlocks Rayson Ho
17:23 Re: performance config help Scott Marlowe
17:25 Re: performance config help Scott Marlowe
17:25 Re: performance config help Bob Dusek
17:26 Re: performance config help Bob Dusek
17:29 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
17:30 Re: performance config help Scott Marlowe
17:30 Re: performance config help Kevin Grittner
17:57 Re: performance config help Bob Dusek
18:13 Re: [PERFORMANCE] work_mem vs temp files issue Robert Haas
18:36 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
18:36 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
18:38 Re: performance config help Scott Marlowe
18:38 Re: performance config help Bob Dusek
18:39 Re: performance config help Scott Marlowe
18:41 Re: performance config help Scott Marlowe
18:41 Re: Choice of bitmap scan over index scan Jeremy Harris
18:45 Re: performance config help Scott Marlowe
19:13 Re: performance config help Dusek, Bob
19:17 Re: performance config help Scott Marlowe
19:18 Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
19:26 Re: performance config help Tom Lane
19:56 Re: performance config help Kevin Grittner
20:12 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
20:32 Re: performance config help Bob Dusek
20:38 Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
20:58 Re: performance config help Kevin Grittner
21:04 Re: performance config help Greg Smith
21:07 Re: performance config help Dusek, Bob
21:12 Re: performance config help Greg Smith
21:15 Re: Choice of bitmap scan over index scan Robert Haas
21:44 Re: performance config help Scott Marlowe
22:17 Re: performance config help Greg Smith
22:29 Re: performance config help Scott Marlowe
22:59 Re: performance config help Pierre Frédéric Caillaud

12 January 2010

16:12 Re: performance config help Matthew Wakeling
16:38 Re: performance config help Kevin Grittner
17:01 Re: performance config help Bob Dusek
17:09 Re: performance config help Bob Dusek
17:29 Re: performance config help Matthew Wakeling

13 January 2010

03:59 a heavy duty operation on an "unused" table kills my server Eduardo Piombino
04:02 Re: performance config help Craig Ringer
04:14 Re: a heavy duty operation on an "unused" table kills my server Craig James
04:41 Re: a heavy duty operation on an "unused" table kills my server Craig Ringer
04:47 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
05:02 Re: a heavy duty operation on an "unused" table kills my server Craig Ringer
05:32 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
06:06 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
06:39 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
07:27 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
09:59 Re: a heavy duty operation on an "unused" table kills my server Craig Ringer
13:15 Re: a heavy duty operation on an "unused" table kills my server Euler Taveira de Oliveira
13:45 Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
14:23 Re: [PERFORMANCE] work_mem vs temp files issue Robert Haas
14:43 Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
14:55 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
15:11 Re: [PERFORMANCE] work_mem vs temp files issue Robert Haas
15:15 Re: [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
15:23 Re: a heavy duty operation on an "unused" table kills my server Robert Haas
15:24 Re: [PERFORMANCE] work_mem vs temp files issue Robert Haas
15:52 Re: a heavy duty operation on an "unused" table kills my server Scott Marlowe
15:53 Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
16:02 Re: [PERFORMANCE] work_mem vs temp files issue Robert Haas
16:54 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
17:11 Re: a heavy duty operation on an "unused" table kills my server Scott Marlowe
17:46 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
18:26 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
19:33 Re: performance config help Bob Dusek
19:44 Re: performance config help Scott Marlowe
21:00 Hashaggregate estimates Jorge Montero
21:08 Re: Hashaggregate estimates Tom Lane
22:12 Re: performance config help Bob Dusek

14 January 2010

04:37 Re: a heavy duty operation on an "unused" table kills my server Craig Ringer
04:45 Re: performance config help Craig Ringer
04:47 Re: performance config help Craig Ringer
09:46 Re: performance config help Dimitri Fontaine
13:29 Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
13:49 Re: a heavy duty operation on an "unused" table kills my server Andy Colson
13:49 Re: Inserting 8MB bytea: just 25% of disk perf used? Ivan Voras
13:59 Slow "Select count(*) ..." query on table with 60 Mio. rows tom
14:04 Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling
14:07 Re: Inserting 8MB bytea: just 25% of disk perf used? Aidan Van Dyk
14:12 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Matthew Wakeling
14:15 Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer
14:18 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows A. Kretschmer
14:48 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Kevin Grittner
14:58 Re: performance config help Pierre Frédéric Caillaud
15:01 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Ivan Voras
15:03 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Kevin Grittner
15:08 Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud
15:15 Re: a heavy duty operation on an "unused" table kills my server Pierre Frédéric Caillaud
16:03 bad execution plan for subselects containing windowing-function Andreas Kretschmer
16:15 Re: bad execution plan for subselects containing windowing-function Tom Lane
16:30 Re: bad execution plan for subselects containing windowing-function Andreas Kretschmer
16:42 Re: bad execution plan for subselects containing windowing-function Tom Lane
17:02 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Greg Smith
17:04 Re: bad execution plan for subselects containing windowing-function Andreas Kretschmer
17:08 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
17:12 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Kevin Grittner
17:15 Re: a heavy duty operation on an "unused" table kills my server Andy Colson
17:25 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Greg Smith
17:31 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
17:31 Re: bad execution plan for subselects containing windowing-function Andreas Kretschmer
17:34 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Kevin Grittner
17:50 Re: Slow "Select count(*) ..." query on table with 60 Mio. rows Greg Smith
18:45 New server to improve performance on our large and busy DB - advice? Carlo Stonebanks
18:45 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
18:54 Re: New server to improve performance on our large and busy DB -advice? Joshua D. Drake
19:03 new server I/O setup Fernando Hevia
19:10 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
19:19 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
19:19 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
19:49 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
20:01 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
20:24 Re: new server I/O setup Scott Marlowe
20:24 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
20:27 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
20:28 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
20:32 Re: Inserting 8MB bytea: just 25% of disk perf used? Fernando Hevia
20:42 Re: Massive table (500M rows) update nightmare Craig James
20:44 Re: New server to improve performance on our large and busy DB - advice? Scott Marlowe
20:45 New server to improve performance on our large and busy DB - advice? (v2) Carlo Stonebanks
21:15 Re: Massive table (500M rows) update nightmare Carlo Stonebanks
21:36 Re: New server to improve performance on our large and busy DB - advice? (v2) Dave Crooke
22:19 Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud
23:46 Re: New server to improve performance on our large and busy DB - advice? (v2) Craig Ringer

15 January 2010

04:17 Re: New server to improve performance on our large and busy DB - advice? Greg Smith
04:39 Re: Inserting 8MB bytea: just 25% of disk perf used? Magnus Hagander
04:46 Re: new server I/O setup Greg Smith
06:17 Re: New server to improve performance on our large and busy DB - advice? Carlo Stonebanks
07:05 Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer
08:50 Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud
09:55 Re: a heavy duty operation on an "unused" table kills my server Matthew Wakeling
10:09 Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling
10:21 Re: new server I/O setup Matthew Wakeling
10:26 Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling
12:43 Re: New server to improve performance on our large and busy DB - advice? (v2) Ivan Voras
13:42 Re: Re: New server to improve performance on our large and busy DB - advice? (v2) Robert Haas
14:18 Re: Re: New server to improve performance on our large and busy DB - advice? (v2) Ing. Marcos L. Ortiz Valmaseda
14:48 Re: new server I/O setup Fernando Hevia
15:17 Re: New server to improve performance on our large and busy DB - advice? (v2) Tony McC
15:20 Re: New server to improve performance on our large and busy DB - advice? (v2) Richard Broersma
15:23 Re: New server to improve performance on our large and busy DB - advice? (v2) Robert Haas
15:46 Re: Re: New server to improve performance on our large and busy DB - advice? (v2) Pierre Frédéric Caillaud
15:49 Re: New server to improve performance on our large and busy DB - advice? marcin mank
15:50 Re: new server I/O setup Fernando Hevia
15:55 Re: New server to improve performance on our large and busy DB - advice? (v2) Tom Lane
16:03 Re: new server I/O setup Fernando Hevia
16:15 Re: a heavy duty operation on an "unused" table kills my server Craig James
16:15 Re: new server I/O setup Matthew Wakeling
16:16 OT: Db2 connection pooling? Alan McKay
16:16 Re: OT: Db2 connection pooling? Alan McKay
16:17 Re: a heavy duty operation on an "unused" table kills my server Matthew Wakeling
16:59 Re: new server I/O setup Pierre Frédéric Caillaud
17:00 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
17:29 Re: New server to improve performance on our large and busy DB - advice? (v2) Greg Smith
18:35 Re: new server I/O setup Fernando Hevia
19:34 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
19:36 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
20:16 Re: Inserting 8MB bytea: just 25% of disk perf used? Merlin Moncure
20:39 Re: New server to improve performance on our large and busy DB - advice? (v2) Scott Marlowe
20:42 Re: new server I/O setup Scott Marlowe
20:55 Re: New server to improve performance on our large and busy DB - advice? (v2) Kevin Grittner
21:32 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
21:53 Bad plan choice nestloop vs. hashjoin Kenneth Marshall
21:59 Re: Bad plan choice nestloop vs. hashjoin Kevin Grittner
23:04 Re: Inserting 8MB bytea: just 25% of disk perf used? Dave Crooke
23:14 Re: Bad plan choice nestloop vs. hashjoin Kenneth Marshall
23:27 Re: Bad plan choice nestloop vs. hashjoin Tom Lane
23:47 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino

16 January 2010

00:38 Re: New server to improve performance on our large and busy DB - advice? (v2) Dave Crooke
00:49 Re: New server to improve performance on our large and busy DB - advice? (v2) Dave Crooke
01:05 Re: New server to improve performance on our large and busy DB - advice? (v2) Tom Lane
01:09 Re: New server to improve performance on our large and busy DB - advice? (v2) Greg Smith
01:25 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
02:06 ext4 finally doing the right thing Greg Smith
03:00 Re: a heavy duty operation on an "unused" table kills my server Craig Ringer
03:44 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
04:18 Re: a heavy duty operation on an "unused" table kills my server Tom Lane
08:09 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
11:49 Re: a heavy duty operation on an "unused" table kills my server Robert Haas
16:47 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
22:22 Re: Inserting 8MB bytea: just 25% of disk perf used? Pierre Frédéric Caillaud

17 January 2010

20:23 Re: a heavy duty operation on an "unused" table kills my server Eduardo Piombino
22:00 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
22:14 Re: a heavy duty operation on an "unused" table kills my server Tom Lane

18 January 2010

10:21 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
12:08 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
12:25 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
15:04 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
15:13 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
15:36 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark
15:38 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
16:13 Re: Bad plan choice nestloop vs. hashjoin Tom Lane
17:57 Re: Bad plan choice nestloop vs. hashjoin Kenneth Marshall
22:48 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey

19 January 2010

09:16 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
09:50 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
09:55 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
10:52 Re: Inserting 8MB bytea: just 25% of disk perf used? Ivan Voras
11:26 Re: Inserting 8MB bytea: just 25% of disk perf used? Richard Huxton
11:59 renice on an I/O bound box Willy-Bas Loos
12:36 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
13:53 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark
13:57 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark
14:03 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund
14:14 Re: Inserting 8MB bytea: just 25% of disk perf used? Kevin Grittner
14:26 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane
14:40 Re: Inserting 8MB bytea: just 25% of disk perf used? Ivan Voras
15:11 Re: renice on an I/O bound box Ing. Marcos L. Ortiz Valmaseda
16:07 Re: renice on an I/O bound box Willy-Bas Loos
19:16 Re: renice on an I/O bound box Arjen van der Meijden
19:19 performance question on VACUUM FULL (Postgres 8.4.2) PG User 2010
19:32 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
20:16 Re: New server to improve performance on our large and busy DB - advice? Carlo Stonebanks
21:38 Re: performance question on VACUUM FULL (Postgres 8.4.2) Jeff Davis
21:57 Re: New server to improve performance on our large and busy DB - advice? Scott Marlowe
22:53 Re: ext4 finally doing the right thing Jeff Davis

20 January 2010

00:19 Re: renice on an I/O bound box Craig Ringer
03:02 Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund
03:02 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund
03:13 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund
04:21 Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith
12:39 Re: a heavy duty operation on an "unused" table kills my server Matthew Wakeling
15:07 Re: Change query join order Kaloyan Iliev Iliev
19:17 Re: New server to improve performance on our large and busy DB - advice? Carlo Stonebanks
19:34 Re: a heavy duty operation on an "unused" table kills my server Greg Smith
19:37 Re: New server to improve performance on our large and busy DB - advice? Kevin Grittner
20:19 Re: ext4 finally doing the right thing Greg Smith
21:47 Re: Re: New server to improve performance on our large and busy DB - advice? (v2) Carlo Stonebanks

21 January 2010

01:03 Re: New server to improve performance on our large and busy DB - advice? Robert Haas
04:15 Re: ext4 finally doing the right thing Greg Stark
04:58 Re: ext4 finally doing the right thing Greg Smith
07:26 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
07:35 Re: Inserting 8MB bytea: just 25% of disk perf used? Greg Smith
10:13 Re: ext4 finally doing the right thing Greg Stark
11:03 Re: a heavy duty operation on an "unused" table kills my server Matthew Wakeling
11:13 Re: Inserting 8MB bytea: just 25% of disk perf used? Matthew Wakeling
12:51 Re: ext4 finally doing the right thing Aidan Van Dyk
13:04 Re: ext4 finally doing the right thing Florian Weimer
13:49 Re: ext4 finally doing the right thing Greg Smith
14:05 Re: ext4 finally doing the right thing Aidan Van Dyk
14:24 Slow update query elias ghanem
14:43 Re: Slow update query Kevin Grittner
14:52 Re: New server to improve performance on our large and busy DB - advice? Alvaro Herrera
14:54 Re: ext4 finally doing the right thing Kevin Grittner
15:24 Re: Inserting 8MB bytea: just 25% of disk perf used? Florian Weimer
15:35 Re: ext4 finally doing the right thing Pierre Frédéric Caillaud
15:41 Re: New server to improve performance on our large and busy DB - advice? Scott Marlowe
15:45 Re: New server to improve performance on our large and busy DB - advice? Alvaro Herrera
15:50 Re: New server to improve performance on our large and busy DB - advice? Scott Marlowe
16:33 Slow update query elias ghanem
17:44 Re: Slow update query Kevin Grittner
18:45 Re: New server to improve performance on our large and busy DB - advice? Devrim GÜNDÜZ
21:15 Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
21:43 Re: performance question on VACUUM FULL (Postgres 8.4.2) PG User 2010
22:17 TPC-C implementation for postgresql? tmp
23:10 Re: TPC-C implementation for postgresql? Greg Smith
23:15 Re: ext4 finally doing the right thing Greg Smith

22 January 2010

02:22 Re: Slow update query Craig Ringer
02:46 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Craig Ringer
07:11 Fragmentation/Vacuum, Analyze, Re-Index DM
08:43 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Richard Huxton
11:40 Slow update query elias ghanem
14:05 Re: Slow update query Robert Haas
16:11 Re: Fragmentation/Vacuum, Analyze, Re-Index DM
16:47 Re: New server to improve performance on our large and busy DB - advice? Carlo Stonebanks
16:59 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
17:03 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
17:25 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Richard Huxton
17:27 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Matthew Wakeling
17:38 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Scott Marlowe
18:06 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
18:08 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
18:28 Re: Fragmentation/Vacuum, Analyze, Re-Index Richard Neill
19:42 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com

23 January 2010

01:25 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Craig Ringer
01:52 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
01:53 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
02:31 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
06:29 Re: Fragmentation/Vacuum, Analyze, Re-Index Reid Thompson

25 January 2010

09:02 Sql result b where condition ramasubramanian
09:16 Re: Sql result b where condition A. Kretschmer
09:54 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Richard Huxton
10:59 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Matthew Wakeling
11:10 Re: Sql result b where condition Matthew Wakeling
11:24 Re: Sql result b where condition A. Kretschmer
13:55 Re: Inserting 8MB bytea: just 25% of disk perf used? fkater@googlemail.com
16:23 splitting data into multiple tables nair rajiv
16:34 Re: splitting data into multiple tables Amitabh Kant
16:39 Re: splitting data into multiple tables Viji V Nair
16:47 Re: splitting data into multiple tables Kevin Grittner
19:15 Re: splitting data into multiple tables Craig James
21:17 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL Tory M Blue
23:40 Re: splitting data into multiple tables nair rajiv
23:49 Re: splitting data into multiple tables Andres Freund

26 January 2010

02:49 Re: splitting data into multiple tables nair rajiv
06:58 Re: splitting data into multiple tables Viji V Nair
10:42 Re: splitting data into multiple tables Matthew Wakeling
10:45 Re: splitting data into multiple tables Matthew Wakeling
14:19 Re: splitting data into multiple tables nair rajiv
15:07 Poor query plan across OR operator Mark Hills
15:10 Re: Poor query plan across OR operator Grzegorz Jaśkiewicz
15:42 Re: Poor query plan across OR operator Tom Lane
16:10 Should the optimiser convert a CASE into a WHERE if it can? Richard Neill
16:21 Re: Should the optimiser convert a CASE into a WHERE if it can? Tom Lane
16:23 Re: Should the optimiser convert a CASE into a WHERE if it can? Matthew Wakeling
16:41 Re: splitting data into multiple tables Greg Smith
16:42 Re: Should the optimiser convert a CASE into a WHERE if it can? Richard Neill
17:23 Re: splitting data into multiple tables Viji V Nair
18:35 Re: Poor query plan across OR operator Robert Haas
19:32 Re: splitting data into multiple tables Greg Smith
19:48 Re: Poor query plan across OR operator Tom Lane
20:05 Re: Poor query plan across OR operator Kevin Grittner
20:28 Re: Inserting 8MB bytea: just 25% of disk perf used? Scott Carey
20:33 Re: Should the optimiser convert a CASE into a WHERE if it can? Scott Carey
20:53 Re: New server to improve performance on our large and busy DB - advice? Greg Smith
21:02 Re: Inserting 8MB bytea: just 25% of disk perf used? Greg Smith

27 January 2010

06:22 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith
12:28 Benchmark shows very slow bulk delete Thom Brown
13:24 Re: Benchmark shows very slow bulk delete Ivan Voras
13:49 Re: Benchmark shows very slow bulk delete Matthew Wakeling
13:54 Re: Benchmark shows very slow bulk delete Kevin Grittner
14:34 test send (recommended by Dave Page) Mark Steben
14:37 Re: test send (recommended by Dave Page) Matthew Wakeling
14:38 Re: Benchmark shows very slow bulk delete Nikolas Everett
14:44 Re: test send (recommended by Dave Page) Dave Page
14:56 Re: Benchmark shows very slow bulk delete Andres Freund
15:53 Re: Should the optimiser convert a CASE into a WHERE if it can? Віталій Тимчишин
16:01 Re: Should the optimiser convert a CASE into a WHERE if it can? Matthew Wakeling
16:11 Re: Should the optimiser convert a CASE into a WHERE if it can? Віталій Тимчишин
20:26 Re: Benchmark shows very slow bulk delete James Mansion
20:41 Re: Benchmark shows very slow bulk delete Greg Smith

28 January 2010

09:53 Re: Benchmark shows very slow bulk delete Ivan Voras
10:21 Constraint propagating for equal fields Віталій Тимчишин

29 January 2010

15:46 Limited Shared Buffer Problem **Rod MacNeil
15:53 Re: Limited Shared Buffer Problem Richard Neill
16:18 Re: Limited Shared Buffer Problem Scott Marlowe
16:21 Re: Limited Shared Buffer Problem Ing . Marcos Luís Ortíz Valmaseda
16:46 Re: Limited Shared Buffer Problem jose javier parra sanchez
17:19 Re: Limited Shared Buffer Problem Cédric Villemain
17:36 Re: Limited Shared Buffer Problem **Rod MacNeil
17:56 Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark
21:19 Re: Limited Shared Buffer Problem Greg Smith

30 January 2010

01:31 Re: Constraint propagating for equal fields Greg Stark
02:55 Slow query: table iteration (8.3) Glenn Maynard