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 - January 2010

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 25 26 27 28 29 30

2010-01-01

Message queue table - strange performance drop with changing limit size. Jesper Krogh (11:48)
Re: Message queue table - strange performance drop with changing limit size. Greg Williamson (14:53)
Re: Message queue table - strange performance drop with changing limit size. Jesper Krogh (15:04)

2010-01-02

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

2010-01-03

Re: Message queue table - strange performance drop with changing limit size. Greg Smith (19:20)

2010-01-04

DB is slow until DB is reloaded Madison Kelly (19:10)
Re: DB is slow until DB is reloaded Gary Doades (19:25)
Re: DB is slow until DB is reloaded Steve Crawford (19:31)
query looping? Brian Cox (19:41)
Re: DB is slow until DB is reloaded Madison Kelly (20:30)
Re: DB is slow until DB is reloaded Richard Neill (20:39)
Re: DB is slow until DB is reloaded Gary Doades (20:40)
Re: DB is slow until DB is reloaded Madison Kelly (20:53)
Re: DB is slow until DB is reloaded Brad Nicholson (21:00)
Re: DB is slow until DB is reloaded Kevin Grittner (21:03)
Re: DB is slow until DB is reloaded Madison Kelly (21:28)
Re: DB is slow until DB is reloaded Madison Kelly (21:33)
Re: DB is slow until DB is reloaded Steve Crawford (21:43)
forced sequential scan when condition has current_user Keresztury Balázs (21:47)
Re: query looping? Robert Haas (21:53)
Re: DB is slow until DB is reloaded Steve Crawford (21:53)
Re: DB is slow until DB is reloaded Madison Kelly (21:54)
Re: DB is slow until DB is reloaded Madison Kelly (21:57)
Re: forced sequential scan when condition has current_user Robert Haas (21:59)
Re: DB is slow until DB is reloaded Rosser Schwarz (22:06)
Re: DB is slow until DB is reloaded Greg Smith (22:13)
Re: query looping? Brian Cox (22:24)
Re: forced sequential scan when condition has current_user Keresztury Balázs (22:49)
Re: DB is slow until DB is reloaded Scott Marlowe (22:51)
Re: forced sequential scan when condition has current_user Erik Jones (23:13)

2010-01-05

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

2010-01-06

Re: DB is slow until DB is reloaded Scott Carey (01:04)
Re: DB is slow until DB is reloaded Craig Ringer (01:16)
Re: query looping? Robert Haas (01:34)
Re: pg_connect takes 3.0 seconds Dmitri Girski (03:25)
Re: pg_connect takes 3.0 seconds Dmitri Girski (03:28)
Re: pg_connect takes 3.0 seconds Dmitri Girski (03:29)
Re: pg_connect takes 3.0 seconds Dmitri Girski (03:49)
Re: pg_connect takes 3.0 seconds Dmitri Girski (04:26)
Re: pg_connect takes 3.0 seconds Scott Marlowe (04:39)
Re: pg_connect takes 3.0 seconds Craig Ringer (04:50)
Re: pg_connect takes 3.0 seconds Matthew Wakeling (10:45)
Re: pg_connect takes 3.0 seconds Robert Haas (16:18)
Re: pg_connect takes 3.0 seconds Dave Crooke (17:04)
Re: pg_connect takes 3.0 seconds Craig James (18:31)
Digesting explain analyze Jesper Krogh (19:10)
Re: Digesting explain analyze Ron Mayer (20:03)
noob inheritance question Zintrigue (23:53)

2010-01-07

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

2010-01-08

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

2010-01-09

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

2010-01-10

Re: PG optimization question Craig Ringer (01:24)
Re: PG optimization question Pierre Frédéric Caillaud (10:52)
Choice of bitmap scan over index scan Mathieu De Zutter (12:28)
Re: Choice of bitmap scan over index scan Jeremy Harris (14:04)
Re: Choice of bitmap scan over index scan Kevin Grittner (15:18)
Re: Choice of bitmap scan over index scan Mathieu De Zutter (15:43)
Re: Choice of bitmap scan over index scan Kevin Grittner (15:53)
Re: Choice of bitmap scan over index scan Kevin Grittner (16:01)
Re: PG optimization question Robert Haas (18:45)

2010-01-11

Re: Choice of bitmap scan over index scan Robert Haas (02:52)
Re: Choice of bitmap scan over index scan Robert Haas (02:53)
Re: Choice of bitmap scan over index scan Mathieu De Zutter (08:36)
Re: Choice of bitmap scan over index scan Matthew Wakeling (10:36)
Re: Choice of bitmap scan over index scan Pierre Frédéric Caillaud (11:23)
Re: PG optimization question Pierre Frédéric Caillaud (11:25)
performance config help Bob Dusek (13:44)
Re: performance config help Scott Marlowe (13:50)
Re: performance config help A. Kretschmer (14:07)
Re: Choice of bitmap scan over index scan Kevin Grittner (15:11)
Re: performance config help Bob Dusek (16:42)
Re: performance config help Bob Dusek (17:10)
Re: performance config help Ivan Voras (17:12)
Re: performance config help Kevin Grittner (17:17)
Re: performance config help Ivan Voras (17:19)
cache false-sharing in lwlocks Rayson Ho (17:24)
Re: performance config help Scott Marlowe (17:34)
Re: performance config help Scott Marlowe (17:47)
Re: performance config help Bob Dusek (17:49)
Re: performance config help Bob Dusek (17:54)

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 25 26 27 28 29 30

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