vacuum full questions

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum full questions
Date: 2009-08-18 21:50:02
Message-ID: 200908181550.02903.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm running a vacuum full on a table due to excessive updates/deletes. It's
been running for more than an hour (it's about 3Gig in size)

2 questions:

1) is there any way to gain some visibility per the progress of the vacuum
full

2) can I safely kill the vacuum full and do a dump, drop table, restore
instead?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2009-08-18 22:24:00 Re: vacuum full questions
Previous Message Scott Marlowe 2009-08-18 20:47:14 Re: vacuum question