Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-01 Chronological Index (1/2)
Last updated: Wed Jan 18 04:12:56 2012
351 messages
31 January 2011
Re: Bloat issue on 8.3; autovac ignores HOT new pages? Scott Marlowe (21:57)
Re: Bloat issue on 8.3; autovac ignores HOT new pages? Mark Kirkwood (21:28)
Re: Bloat issue on 8.3; autovac ignores HOT new pages? Josh Berkus (18:58)
Re: Any experience using "shake" defragmenter? Florian Weimer (16:50)
Re: Any experience using "shake" defragmenter? Florian Weimer (16:49)
Re: Any experience using "shake" defragmenter? Lew (12:56)
Re: Migrating to Postgresql and new hardware Lars (10:18)
Re: Any experience using "shake" defragmenter? Mladen Gogala (04:53)
Re: Any experience using "shake" defragmenter? Mladen Gogala (04:49)
30 January 2011
Re: Any experience using "shake" defragmenter? Marcin Mirosław (22:35)
Re: postgres 9 query performance Tom Lane (22:22)
Re: Any experience using "shake" defragmenter? Mark Felder (21:31)
Any experience using "shake" defragmenter? Mladen Gogala (20:19)
Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1 Robert Haas (19:25)
Re: How to best use 32 15k.7 300GB drives? Віталій Тимчишин (16:26)
29 January 2011
28 January 2011
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel (21:33)
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel (21:19)
Re: postgres 9 query performance Andres Freund (21:19)
Re: postgres 9 query performance yazan suleiman (21:01)
Re: postgres 9 query performance Kenneth Marshall (20:50)
Re: postgres 9 query performance Scott Marlowe (20:34)
Re: How to best use 32 15k.7 300GB drives? Scott Marlowe (18:55)
Re: FW: Queries becoming slow under heavy load Mladen Gogala (18:46)
Re: How to best use 32 15k.7 300GB drives? Scott Carey (17:48)
Re: How to best use 32 15k.7 300GB drives? Scott Carey (17:45)
Re: How to best use 32 15k.7 300GB drives? Scott Carey (17:42)
postgres 9 query performance yazan suleiman (17:30)
Re: How to best use 32 15k.7 300GB drives? Stephen Frost (17:28)
Re: How to best use 32 15k.7 300GB drives? Stephen Frost (17:14)
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel (17:10)
Re: How to best use 32 15k.7 300GB drives? Scott Marlowe (17:00)
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel (16:40)
Re: FW: Queries becoming slow under heavy load Shaun Thomas (15:31)
Re: High load, Ivan Voras (14:06)
Re: How to best use 32 15k.7 300GB drives? Grant Johnson (13:24)
Re: High load, Mladen Gogala (13:17)
Re: How to best use 32 15k.7 300GB drives? Stephen Frost (13:14)
Re: High load, Michael Kohl (08:46)
Re: FW: Queries becoming slow under heavy load Anne Rosset (05:12)
Re: How to best use 32 15k.7 300GB drives? david (00:53)
Re: How to best use 32 15k.7 300GB drives? Robert Schnabel (00:27)
Re: How to best use 32 15k.7 300GB drives? Alan Hodgson (00:11)
27 January 2011
How to best use 32 15k.7 300GB drives? Robert Schnabel (23:11)
Re: Postgres 9.0 has a bias against indexes Kevin Grittner (21:43)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (21:33)
Re: Postgres 9.0 has a bias against indexes Scott Marlowe (21:33)
Re: Postgres 9.0 has a bias against indexes Igor Neyman (21:32)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (21:31)
Re: Postgres 9.0 has a bias against indexes Scott Marlowe (21:29)
Re: Postgres 9.0 has a bias against indexes Kenneth Marshall (21:21)
Re: Postgres 9.0 has a bias against indexes Igor Neyman (21:18)
Re: Postgres 9.0 has a bias against indexes Scott Marlowe (21:16)
Re: Postgres 9.0 has a bias against indexes Igor Neyman (21:13)
Re: Postgres 9.0 has a bias against indexes Scott Marlowe (20:59)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (20:44)
Re: Postgres 9.0 has a bias against indexes Scott Marlowe (20:37)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (20:32)
Re: High load, Ing. Marcos Ortiz Valmaseda (20:21)
Re: Postgres 9.0 has a bias against indexes Igor Neyman (20:11)
Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1 DM (19:26)
Re: High load, Andres Freund (18:19)
Re: High load, Scott Marlowe (18:14)
Re: High load, Scott Marlowe (18:13)
Re: High load, Stephen Frost (17:54)
Re: High load, Andy Colson (17:20)
Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian (17:07)
Re: High load, Scott Marlowe (17:05)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (17:00)
Re: Running PostgreSQL as fast as possible no matter the consequences Jeff Janes (16:51)
Re: Postgres 9.0 has a bias against indexes Tom Lane (16:40)
Re: Real vs Int performance Igor Neyman (16:17)
Re: Postgres 9.0 has a bias against indexes David Wilson (16:09)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (15:57)
Re: Postgres 9.0 has a bias against indexes Mladen Gogala (15:56)
Re: Postgres 9.0 has a bias against indexes J Sisson (15:51)
Re: Postgres 9.0 has a bias against indexes Kevin Grittner (15:49)
Re: Postgres 9.0 has a bias against indexes Kenneth Marshall (15:45)
Postgres 9.0 has a bias against indexes Mladen Gogala (15:41)
Re: Real vs Int performance Mladen Gogala (15:11)
Re: High load, Michael Kohl (15:09)
Re: High load, Andy Colson (15:06)
Re: Why I lost the last pg_xlog file? Kevin Grittner (14:51)
Re: Real vs Int performance Shaun Thomas (14:30)
Re: Real vs Int performance Tom Lane (14:18)
Re: Why I lost the last pg_xlog file? Shaun Thomas (14:17)
Re: Real vs Int performance David Greco (14:04)
Re: High load, Andres Freund (13:26)
Re: High load, Cédric Villemain (13:24)
Re: High load, Michael Kohl (12:56)
Re: High load, Andres Freund (12:35)
Re: High load, Justin Pitts (12:31)
Why I lost the last pg_xlog file? Waldomiro (12:25)
Re: High load, Cédric Villemain (11:58)
Re: High load, Michael Kohl (11:38)
Re: High load, Cédric Villemain (11:24)
High load, Michael Kohl (10:37)
Re: FW: Queries becoming slow under heavy load Scott Marlowe (05:07)
Re: FW: Queries becoming slow under heavy load Scott Marlowe (04:18)
Re: Queries becoming slow under heavy load mark (02:35)
Re: anti-join chosen even when slower than old plan Bruce Momjian (01:41)
26 January 2011
Re: Real vs Int performance Kevin Grittner (21:53)
Real vs Int performance David Greco (19:47)
Re: FW: Queries becoming slow under heavy load Shaun Thomas (17:16)
FW: Queries becoming slow under heavy load Anne Rosset (16:04)
Re: Queries becoming slow under heavy load Ivan Voras (13:25)
Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian (01:32)
25 January 2011
Re: Queries becoming slow under heavy load Kevin Grittner (22:12)
Re: Queries becoming slow under heavy load Andy Colson (22:12)
Queries becoming slow under heavy load Anne Rosset (21:50)
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Mark Kirkwood (21:29)
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus (18:28)
Re: Bloat issue on 8.3; autovac ignores HOT page splits? Robert Haas (16:41)
Re: Fun little performance IMPROVEMENT... Ivan Voras (15:27)
Re: Possible to improve query plan? Cédric Villemain (13:44)
Re: How to use indexes for GROUP BY Dimi Paun (05:03)
Bloat issue on 8.3; autovac ignores HOT page splits? Josh Berkus (02:26)
Re: Possible to improve query plan? Jeremy Palmer (00:25)
Re: Possible to improve query plan? Kevin Grittner (00:01)
24 January 2011
Re: Possible to improve query plan? Jeremy Palmer (21:55)
Re: How to use indexes for GROUP BY hubert depesz lubaczewski (20:07)
Re: How to use indexes for GROUP BY Scott Marlowe (19:33)
Re: How to use indexes for GROUP BY Shaun Thomas (19:27)
How to use indexes for GROUP BY Dimi Paun (19:01)
Re: Possible to improve query plan? Kevin Grittner (17:38)
Re: Possible to improve query plan? Tom Lane (17:33)
Re: Possible to improve query plan? Tom Lane (17:31)
Re: Possible to improve query plan? Kevin Grittner (16:50)
Re: Possible to improve query plan? Robert Haas (16:33)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (15:40)
23 January 2011
21 January 2011
Re: Fun little performance IMPROVEMENT... grant (21:30)
Re: Fun little performance IMPROVEMENT... grant (21:28)
Re: Fun little performance IMPROVEMENT... Scott Carey (21:08)
Re: Fun little performance IMPROVEMENT... grant (20:27)
Re: Fun little performance IMPROVEMENT... grant (20:22)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane (20:22)
Re: Fun little performance IMPROVEMENT... Greg Smith (20:19)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Kevin Grittner (20:00)
Re: Fun little performance IMPROVEMENT... Tom Lane (19:50)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane (19:26)
Re: Best way to get the latest revision from a table Nikolas Everett (18:55)
Re: Fun little performance IMPROVEMENT... Andy Colson (18:29)
Fun little performance IMPROVEMENT... grant (18:16)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (18:13)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas (17:51)
Re: the XID question Robert Haas (17:49)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (17:42)
Re: Best way to get the latest revision from a table Robert Haas (17:14)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas (17:09)
20 January 2011
Re: copy command and blobs Mladen Gogala (20:17)
copy command and blobs Madhu Ramachandran (20:12)
Re: the XID question Kevin Grittner (17:05)
Re: anti-join chosen even when slower than old plan Cédric Villemain (16:36)
Re: anti-join chosen even when slower than old plan Cédric Villemain (16:16)
Re: Migrating to Postgresql and new hardware Scott Marlowe (15:44)
Re: Running PostgreSQL as fast as possible no matter the consequences Robert Haas (15:25)
Re: Migrating to Postgresql and new hardware Andy Colson (14:48)
Re: anti-join chosen even when slower than old plan Robert Haas (14:19)
Re: anti-join chosen even when slower than old plan Cédric Villemain (09:17)
Re: the XID question Charles.Hou (07:55)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (07:05)
Re: Migrating to Postgresql and new hardware Craig Ringer (00:43)
19 January 2011
Re: anti-join chosen even when slower than old plan Bruce Momjian (20:04)
Re: anti-join chosen even when slower than old plan Bruce Momjian (20:03)
Re: anti-join chosen even when slower than old plan Bruce Momjian (19:47)
Re: the XID question Kevin Grittner (18:41)
Re: the XID question Andres Freund (18:32)
Re: the XID question Chris Browne (18:25)