vacuum full questions - Mailing list pgsql-admin

From Kevin Kempter
Subject vacuum full questions
Date
Msg-id 200908181550.02903.kevink@consistentstate.com
Whole thread Raw
Responses Re: vacuum full questions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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?



pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: vacuum question
Next
From: "Kevin Grittner"
Date:
Subject: Re: vacuum full questions