Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-03 Chronological Index (1/3)
Last updated: Wed Jan 18 04:12:43 2012
383 messages
31 March 2011
Re: Calculating 95th percentiles Landreville (17:31)
Why it is using/not using index scan? Laszlo Nagy (17:26)
Re: COPY with high # of clients, partitioned table locking issues? Maciek Sakrejda (16:53)
Re: Slow deleting tables with foreign keys Bob Lunney (14:54)
Re: COPY with high # of clients, partitioned table locking issues? Emanuel Calvo (10:43)
Slow deleting tables with foreign keys Jeremy Palmer (02:16)
Re: COPY with high # of clients, partitioned table locking issues? Samuel Gendler (01:31)
Re: COPY with high # of clients, partitioned table locking issues? Bob Lunney (00:48)
30 March 2011
Re: very long updates very small tables Kevin Grittner (16:55)
Re: very long updates very small tables pasman pasmański (15:24)
Re: Why Index is not used Greg Smith (07:55)
Re: very long updates very small tables Lars Feistner (07:35)
Re: multiple table scan performance Craig James (01:11)
Re: multiple table scan performance Samuel Gendler (00:12)
Re: multiple table scan performance Marti Raudsepp (00:05)
29 March 2011
multiple table scan performance Samuel Gendler (22:18)
Re: Intel SSDs that may not suck Jesper Krogh (20:13)
Re: very long updates very small tables Kevin Grittner (20:06)
Re: Intel SSDs that may not suck Greg Smith (19:28)
Re: Intel SSDs that may not suck gnuoytr (16:58)
Re: Intel SSDs that may not suck Jeff (16:51)
Re: Intel SSDs that may not suck Jesper Krogh (16:12)
Re: Intel SSDs that may not suck Strange, John W (15:37)
very long updates very small tables Lars Feistner (15:07)
Re: Intel SSDs that may not suck Jeff (14:33)
Re: Intel SSDs that may not suck Cédric Villemain (14:31)
Re: Intel SSDs that may not suck Jeff (14:17)
Re: Intel SSDs that may not suck Yeb Havinga (10:34)
Re: Intel SSDs that may not suck Scott Marlowe (05:02)
Re: Intel SSDs that may not suck Jesper Krogh (04:55)
Re: Intel SSDs that may not suck Merlin Moncure (04:14)
Re: Intel SSDs that may not suck Justin Pitts (01:42)
28 March 2011
Re: buffercache/bgwriter Uwe Bartels (20:23)
Intel SSDs that may not suck Greg Smith (20:21)
Re: Xeon twice the performance of opteron Greg Smith (06:21)
Re: buffercache/bgwriter Greg Smith (06:18)
26 March 2011
25 March 2011
Re: Shouldn't we have a way to avoid "risky" plans? Scott Carey (18:02)
Re: Analyze on temp table taking very long Mahadevan, Mridula (17:34)
Re: Why Index is not used Maciek Sakrejda (16:49)
Re: Shouldn't we have a way to avoid "risky" plans? Vitalii Tymchyshyn (14:41)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Strange, John W (14:32)
Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane (14:24)
Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane (14:12)
Re: Why Index is not used Shaun Thomas (13:25)
Re: Slow query on CLUTER -ed tables Laszlo Nagy (12:24)
Re: Why Index is not used Adarsh Sharma (09:48)
Re: Shouldn't we have a way to avoid "risky" plans? Vitalii Tymchyshyn (09:43)
Re: Why Index is not used tv (09:30)
Re: Why Index is not used Chetan Suttraway (09:08)
Re: Why Index is not used Adarsh Sharma (08:50)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Marti Raudsepp (08:30)
Re: Why Index is not used Chetan Suttraway (08:14)
Re: Why Index is not used Thomas Kellerer (07:24)
Re: Why Index is not used Adarsh Sharma (07:04)
Re: Why Index is not used Chetan Suttraway (06:56)
Re: Why Index is not used Adarsh Sharma (06:47)
Re: Why Index is not used Andreas Kretschmer (06:44)
Why Index is not used Adarsh Sharma (06:31)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration DM (01:12)
24 March 2011
Re: Shouldn't we have a way to avoid "risky" plans? Nathan Boley (20:31)
Re: Shouldn't we have a way to avoid "risky" plans? Merlin Moncure (19:31)
Re: maintenance_work_mem + create index Euler Taveira de Oliveira (17:35)
Re: maintenance_work_mem + create index Shaun Thomas (15:39)
Re: maintenance_work_mem + create index Uwe Bartels (15:29)
Re: maintenance_work_mem + create index Shaun Thomas (15:15)
Re: maintenance_work_mem + create index Uwe Bartels (14:40)
Re: maintenance_work_mem + create index Stephen Frost (14:13)
maintenance_work_mem + create index Uwe Bartels (13:56)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Achilleas Mantzios (12:07)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Marti Raudsepp (11:40)
Re: buffercache/bgwriter Uwe Bartels (09:19)
Re: pg9.0.3 explain analyze running very slow compared to a different box with much less configuration Achilleas Mantzios (09:11)
Re: Shouldn't we have a way to avoid "risky" plans? Віталій Тимчишин (08:44)
Re: Re-Reason of Slowness of Query Adarsh Sharma (05:05)
pg9.0.3 explain analyze running very slow compared to a different box with much less configuration DM (02:04)
Re: Shouldn't we have a way to avoid "risky" plans? Josh Berkus (00:06)
23 March 2011
Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire (21:08)
Re: Shouldn't we have a way to avoid "risky" plans? Tom Lane (21:00)
Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire (20:46)
Slow query on CLUTER -ed tables Laszlo Nagy (20:35)
Re: Shouldn't we have a way to avoid "risky" plans? Josh Berkus (20:29)
Re: buffercache/bgwriter Cédric Villemain (20:24)
Re: Shouldn't we have a way to avoid "risky" plans? Justin Pitts (18:02)
Re: Shouldn't we have a way to avoid "risky" plans? Claudio Freire (17:37)
Shouldn't we have a way to avoid "risky" plans? Josh Berkus (17:12)
Re: buffercache/bgwriter Jeff Janes (16:16)
Re: buffercache/bgwriter Uwe Bartels (16:16)
Re: buffercache/bgwriter Jeff Janes (15:40)
Re: buffercache/bgwriter Uwe Bartels (15:26)
Re: buffercache/bgwriter Nicholson, Brad (Toronto, ON, CA) (15:00)
Re: buffercache/bgwriter Uwe Bartels (14:54)
Re: buffercache/bgwriter tv (14:42)
Re: Re-Reason of Slowness of Query Shaun Thomas (14:20)
Re: Re-Reason of Slowness of Query tv (14:16)
Re: buffercache/bgwriter Uwe Bartels (13:40)
Re: Re-Reason of Slowness of Query Shaun Thomas (13:34)
Re: buffercache/bgwriter Jochen Erwied (13:20)
Re: good old VACUUM FULL Shaun Thomas (13:13)
buffercache/bgwriter Uwe Bartels (12:51)
Re: Re-Reason of Slowness of Query tv (11:52)
Re: Re-Reason of Slowness of Query Adarsh Sharma (11:34)
Re: Re-Reason of Slowness of Query Adarsh Sharma (11:26)
Re: Re-Reason of Slowness of Query Chetan Suttraway (11:24)
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn (11:21)
Re: Re-Reason of Slowness of Query Adarsh Sharma (11:16)
Re: Re-Reason of Slowness of Query Chetan Suttraway (10:51)
Re: Re-Reason of Slowness of Query Chetan Suttraway (10:40)
Re: Re-Reason of Slowness of Query tv (10:38)
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn (10:37)
Re: Re-Reason of Slowness of Query Adarsh Sharma (10:14)
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn (10:12)
Re: Re-Reason of Slowness of Query Adarsh Sharma (10:05)
Re: Re-Reason of Slowness of Query Vitalii Tymchyshyn (09:27)
Re-Reason of Slowness of Query Adarsh Sharma (09:13)
Re: Reason of Slowness of query Vitalii Tymchyshyn (08:51)
Re: Reason of Slowness of query Chetan Suttraway (07:26)
Re: Reason of Slowness of query Adarsh Sharma (07:25)
Re: Reason of Slowness of query Vitalii Tymchyshyn (07:25)
Re: Reason of Slowness of query Samuel Gendler (07:21)
Re: Reason of Slowness of query Chetan Suttraway (07:17)
Reason of Slowness of query Adarsh Sharma (06:23)
Re: good old VACUUM FULL Scott Marlowe (06:17)
Re: ANTI-JOIN needs table, index scan not possible? Robert Haas (04:32)
Re: good old VACUUM FULL Chris (04:25)
good old VACUUM FULL felix (00:53)
22 March 2011
Re: Performance on AIX Josh Berkus (21:29)
Analyze on temp table taking very long Mahadevan, Mridula (16:20)
Re: Help: massive parallel update to the same table Red Maple (14:13)
Re: Request for feedback on hardware for a new database server Merlin Moncure (13:54)
Re: Select in subselect vs select = any array mark (02:56)
Re: REINDEX takes half a day (and still not complete!) Scott Marlowe (02:48)
21 March 2011
Re: Select in subselect vs select = any array Pavel Stehule (06:39)
Re: Select in subselect vs select = any array Adam Tistler (06:17)
Re: Select in subselect vs select = any array Pavel Stehule (05:56)
Re: Select in subselect vs select = any array Adam Tistler (03:21)
20 March 2011
Re: Select in subselect vs select = any array Pavel Stehule (06:52)
Select in subselect vs select = any array Adam Tistler (06:47)
19 March 2011
Re: Performance on AIX Andy Colson (13:17)
Performance on AIX phb07 (09:00)
Re: REINDEX takes half a day (and still not complete!) Scott Marlowe (05:30)
Re: REINDEX takes half a day (and still not complete!) Scott Marlowe (04:58)
REINDEX takes half a day (and still not complete!) Phoenix Kiula (03:07)
18 March 2011
Re: Help: massive parallel update to the same table Kevin Grittner (19:21)
Re: Fastest pq_restore? Andy Colson (19:10)
Re: Help: massive parallel update to the same table Red Maple (18:21)
Re: Request for feedback on hardware for a new database server Scott Marlowe (16:32)
Re: Help: massive parallel update to the same table Kevin Grittner (16:07)
Re: Request for feedback on hardware for a new database server Claudio Freire (16:02)
Re: Help with Query Tuning tv (15:30)
Re: Disabling nested loops - worst case performance Claudio Freire (15:26)
Re: Fastest pq_restore? Kevin Grittner (14:38)
Re: Help: massive parallel update to the same table Nicholson, Brad (Toronto, ON, CA) (14:34)
Re: Help: massive parallel update to the same table Kevin Grittner (14:28)
Re: Help with Query Tuning Reid Thompson (14:05)
Help: massive parallel update to the same table Red Maple (13:05)
Re: Request for feedback on hardware for a new database server Arjen van der Meijden (12:45)
Re: Xeon twice the performance of opteron Jeff (12:15)
Re: Disabling nested loops - worst case performance Anssi Kääriäinen (12:01)
Re: Disabling nested loops - worst case performance Anssi Kääriäinen (11:41)
Re: Disabling nested loops - worst case performance Thomas Kellerer (11:14)
Re: Disabling nested loops - worst case performance Vitalii Tymchyshyn (10:52)
Re: Disabling nested loops - worst case performance Anssi Kääriäinen (10:41)
Re: Request for feedback on hardware for a new database server Scott Marlowe (09:11)
Re: Request for feedback on hardware for a new database server Arjen van der Meijden (07:17)
Re: Disabling nested loops - worst case performance Pavel Stehule (07:02)