Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2006-06 Chronological Index (1/3)
Last updated: Wed Jan 18 04:18:35 2012
504 messages
30 June 2006
Re: [pgadmin-support] 100% CPU Jim C. Nasby (17:58)
Re: FWD: Update touches unrelated indexes? Alvaro Herrera (17:28)
Re: Index Being Ignored? Joe Lester (16:31)
Re: FWD: Update touches unrelated indexes? Jozsef Szalay (15:26)
Re: Index Being Ignored? Tom Lane (14:41)
Re: newly created database makes queries run 300% faster Brad Nicholson (14:36)
Re: Index Being Ignored? Markus Schaber (14:29)
newly created database makes queries run 300% faster Ksenia Marasanova (14:14)
Index Being Ignored? Joe Lester (14:05)
Re: FWD: Update touches unrelated indexes? Tom Lane (06:44)
FWD: Update touches unrelated indexes? Josh Berkus (06:33)
Re: Sort order in sub-select Tom Lane (06:21)
Re: explain analyze reports 20x more time than actual Tom Lane (06:05)
Sort order in sub-select Craig A. James (05:56)
explain analyze reports 20x more time than actual Craig A. James (05:54)
28 June 2006
Re: Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32) Jim C. Nasby (15:08)
Re: Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32) Tom Lane (14:37)
Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32) Andrew Sagulin (09:34)
27 June 2006
Re: why group expressions cause query to run forever Andrus (18:02)
unregister Leandro Guimarães dos Santos (17:16)
unregister Gourish Singbal (14:04)
Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32) Andrew Sagulin (12:23)
Re: Some performance numbers, with thoughts Simon Riggs (07:13)
26 June 2006
Re: Some performance numbers, with thoughts Michael Stone (21:22)
Re: Some performance numbers, with thoughts Simon Riggs (19:34)
Re: Occupation bloc in pages of table luchot (12:34)
Re: Occupation bloc in pages of table luchot (12:34)
Re: why group expressions cause query to run forever Andrus (12:20)
Re: Occupation bloc in pages of table luchot (12:16)
24 June 2006
RES: Temporary table Franklin Haut (00:22)
23 June 2006
Re: Temporary table Tom Lane (22:04)
Temporary table Franklin Haut (21:52)
Buffers to Nest Loop Join Daniel Xavier de Sousa (18:39)
Re: Occupation bloc in pages of table Tom Lane (16:09)
Re: Help tuning autovacuum - seeing lots of relationbloat Markus Schaber (12:40)
Re: Help tuning autovacuum - seeing lots of relationbloat Markus Schaber (12:32)
Re: SAN performance mystery Markus Schaber (12:02)
Re: SAN performance mystery Markus Schaber (11:56)
Occupation bloc in pages of table luchot (10:29)
Re: Why is my (empty) partial index query slow? Tom Lane (00:44)
Re: Query hanging/not finishing inconsistently Tom Lane (00:31)
22 June 2006
Re: why group expressions cause query to run forever Tom Lane (19:30)
why group expressions cause query to run forever Andrus (18:23)
Re: Performance of DOMAINs David Wheeler (18:18)
Re: Performance of DOMAINs David Wheeler (18:18)
Re: Performance of DOMAINs David Wheeler (18:11)
Re: Poor performance - fixed by restart Tom Lane (16:24)
Re: Tuning New Server (slow function) Tom Lane (16:19)
Re: Why is my (empty) partial index query slow? Tom Lane (16:05)
Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL Craig A. James (15:04)
Re: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed Tom Lane (14:47)
Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL Arjen van der Meijden (14:19)
Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL David Roussel (13:22)
Re: Speeding up query, Joining 55mil and 43mil records. Sven Geisler (12:20)
Re: Speeding up query, Joining 55mil and 43mil records. Magnus Hagander (12:17)
Re: Speeding up query, Joining 55mil and 43mil records. nicky (12:11)
Re: Speeding up query, Joining 55mil and 43mil records. Sven Geisler (11:29)
Re: Speeding up query, Joining 55mil and 43mil records. nicky (09:48)
Regarding ERROR: fmgr_info: function 2720768: cache lookup failed soni de (04:58)
Re: Performance of DOMAINs Michael Glaesemann (02:24)
Re: Performance of DOMAINs Josh Berkus (01:19)
21 June 2006
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (23:09)
Re: Tuning New Server (slow function) Ron St-Pierre (22:56)
Re: Tuning New Server (slow function) Jim C. Nasby (22:36)
Re: Help tuning autovacuum - seeing lots of relationbloat Jim C. Nasby (22:36)
Tuning New Server (slow function) Ron St-Pierre (21:31)
Re: Quick question about top... Steinar H. Gunderson (21:18)
Quick question about top... Alex Turner (20:46)
Re: Performance of DOMAINs Tom Lane (20:08)
Re: Big array speed issues Merlin Moncure (19:49)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (19:41)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (19:40)
Re: Help tuning autovacuum - seeing lots of relationbloat Jim C. Nasby (19:38)
Re: Performance of DOMAINs Jim C. Nasby (19:02)
Re: Help tuning autovacuum - seeing lots of relation bloat Jim C. Nasby (18:58)
Re: Speeding up query, Joining 55mil and 43mil records. Jim C. Nasby (18:48)
Re: Big array speed issues Jim C. Nasby (18:33)
Performance of DOMAINs David Wheeler (18:26)
Re: Speeding up query, Joining 55mil and 43mil records. Tom Lane (17:12)
Re: Speeding up query, Joining 55mil and 43mil records. Scott Marlowe (17:03)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (16:49)
Re: Help tuning autovacuum - seeing lots of relationbloat Csaba Nagy (16:44)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (16:39)
Re: Help tuning autovacuum - seeing lots of relationbloat Csaba Nagy (16:36)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (16:34)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (16:21)
Tuning New Server (slow function) Ron St-Pierre (15:59)
Re: Help tuning autovacuum - seeing lots of relationbloat Csaba Nagy (15:42)
Tuning New Server (slow function) Ron St-Pierre (15:42)
Re: Speeding up query, Joining 55mil and 43mil records. Sven Geisler (15:37)
Re: Help tuning autovacuum - seeing lots of relationbloat jody brownell (15:27)
Re: Speeding up query, Joining 55mil and 43mil records. Dave Dutcher (14:53)
Speeding up query, Joining 55mil and 43mil records. nicky (14:19)
Re: Help tuning autovacuum - seeing lots of relation Tom Lane (14:17)
Re: Help tuning autovacuum - seeing lots of relation Csaba Nagy (14:08)
Help tuning autovacuum - seeing lots of relation bloat jody brownell (13:53)
Re: Some queries starting to hang Markus Schaber (07:49)
Re: scaling up postgres Markus Schaber (07:33)
Re: Big array speed issues Merkel Marcel (CR/AEM4) (07:32)
Re: scaling up postgres Markus Schaber (07:28)
ACL cleanup Eric Lauzon (04:52)
Re: Big array speed issues Merlin Moncure (02:56)
20 June 2006
Re: lowering priority automatically at connection Markus Schaber (15:12)
Re: Curson prbolem Tom Lane (14:28)
Curson prbolem biuro (13:02)
Big array speed issues Merkel Marcel (CR/AEM4) (09:59)
Re: Some performance numbers, with thoughts Luke Lonergan (01:24)
Re: Some performance numbers, with thoughts Tom Lane (01:18)
Some performance numbers, with thoughts Brian Hurt (00:09)
19 June 2006
Re: SAN performance mystery Stephen Frost (15:04)
Re: SAN performance mystery John Vincent (13:00)
Re: SAN performance mystery John Vincent (12:58)
Re: SAN performance mystery John Vincent (12:54)
Re: SAN performance mystery Stephen Frost (12:42)
Re: SAN performance mystery Tim Allen (10:28)
Re: SAN performance mystery Michael Stone (10:24)
Re: SAN performance mystery Tim Allen (10:09)
Re: SAN performance mystery Tim Allen (06:12)
18 June 2006
17 June 2006
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community Jim Nasby (20:00)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community Jim Nasby (19:59)
Re: SAN performance mystery Jim Nasby (19:59)
Re: Optimizer internals Jim Nasby (19:54)
Re: Precomputed constants? Jim Nasby (19:45)
Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL Josh Berkus (19:19)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community Robert Lor (04:19)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tatsuo Ishii (03:05)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tom Lane (02:34)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL Tatsuo Ishii (02:02)
16 June 2006
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community Arjen van der Meijden (22:34)
Re: Question about clustering multiple columns Benjamin Arai (19:00)
Re: Question about clustering multiple columns Bruno Wolff III (18:52)
Re: SAN performance mystery Jeff Trout (17:58)
Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community Josh Berkus (17:02)
Re: Question about clustering multiple columns Bruno Wolff III (15:28)
Sun Donated a Sun Fire T2000 to the PostgreSQL community Robert Lor (15:22)
Re: SAN performance mystery Merlin Moncure (14:19)
Re: Optimizer internals Jonah H. Harris (13:44)
Re: Delete operation VERY slow... Tom Lane (13:30)
Re: Optimizer internals Greg Stark (13:21)
Re: Optimizer internals Jonah H. Harris (12:51)
Re: how to partition disks Michael Stone (12:23)
Re: SAN performance mystery Mikael Carneholm (11:44)
Re: SAN performance mystery Greg Stark (11:29)
Re: Optimizer internals Greg Stark (11:23)
Re: Delete operation VERY slow... PFC (11:22)
Re: SAN performance mystery Tim Allen (09:11)
Re: Delete operation VERY slow... David Leangen (08:13)
Re: SAN performance mystery Stefan Kaltenbrunner (07:48)
Why is my (empty) partial index query slow? Richard Frith-Macdonald (07:39)
Re: Delete operation VERY slow... Gourish Singbal (07:23)
Re: Delete operation VERY slow... A. Kretschmer (07:17)
Delete operation VERY slow... David Leangen (07:06)
Re: Performance of pg_dump on PGSQL 8.0 Merlin Moncure (01:04)
Re: Optimizer internals Mischa Sandberg (00:28)
15 June 2006
Re: SAN performance mystery Mark Lewis (23:25)
Re: Optimizer internals John Vincent (23:23)
Re: SAN performance mystery Tom Lane (22:24)
Re: Optimizer internals Jim C. Nasby (22:23)
Re: SAN performance mystery John Vincent (22:15)
Re: SAN performance mystery Brian Hurt (22:02)
Re: SAN performance mystery Scott Marlowe (21:57)
SAN performance mystery Tim Allen (21:50)
Re: Optimizer internals John Vincent (19:43)
Re: Optimizer internals John Vincent (19:38)
Re: Optimizer internals Scott Marlowe (19:26)