Re: Curious about dead rows.
От
Andrew Sullivan
Тема
Re: Curious about dead rows.
Дата
Msg-id
20071114152249.GA16041@crankycanuck.ca
Ответ на
Re: Curious about dead rows. (Jean-David Beyer)
Список
Дерево обсуждения
Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Tom Lane <tgl@sss.pgh.pa.us>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. "Joshua D. Drake" <jd@commandprompt.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Andrew Sullivan <ajs@crankycanuck.ca>
Re: Curious about dead rows. "Merlin Moncure" <mmoncure@gmail.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. "Merlin Moncure" <mmoncure@gmail.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Andrew Sullivan <ajs@crankycanuck.ca>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Andrew Sullivan <ajs@crankycanuck.ca>
Re: Curious about dead rows. Andrew Sullivan <ajs@crankycanuck.ca>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Russell Smith <mr-russ@pws.com.au>
Re: Curious about dead rows. Tom Lane <tgl@sss.pgh.pa.us>
Re: Curious about dead rows. Brad Nicholson <bnichols@ca.afilias.info>
Re: Curious about dead rows. "Merlin Moncure" <mmoncure@gmail.com>
Re: Curious about dead rows. "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Erik Jones <erik@myemma.com>
Re: Curious about dead rows. Mario Weilguni <mweilguni@sime.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
Re: Curious about dead rows. Craig James <craig_james@emolecules.com>
Re: Curious about dead rows. Jean-David Beyer <jeandavid8@verizon.net>
On Wed, Nov 14, 2007 at 07:12:45AM -0500, Jean-David Beyer wrote: > > I know there have been rollbacks but I do a REINDEX, CLUSTER, and VACUUM > ANALYZE before starting the inserts in question. Do I need to do a VACUUM > FULL ANALYZE instead? I had another idea. As Alvaro says, CLUSTER will do everything you need. But are you sure there are _no other_ transactions open when you do that? This could cause problems, and CLUSTER's behaviour with other open transactions is not, um, friendly prior to the current beta. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke
В списке pgsql-performance по дате отправления
