Long time Vacuum full - Mailing list pgsql-novice

From Patrick Hatcher
Subject Long time Vacuum full
Date
Msg-id OF3C313EFA.D5C49ED5-ON88256CB7.00782514@fds.com
Whole thread Raw
Responses Re: Long time Vacuum full  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Should it take over 8 hours to do a vacuum full analyze on a 15 million
record table?  I have no idea when, if ever, this user has done a vacuum
full on this machine.
Checking the log, it appears it has gone through and taken care of the
indexes, but there are  hundreds of lines
DEBUG:  recycled transaction log file XXXXXXXXXXXXXXXX.
I'm afraid to cancel the process for fear of corrupting the table.

Patrick Hatcher
Macys.Com




pgsql-novice by date:

Previous
From: Rob Klaus
Date:
Subject: ODBC Documentation
Next
From: "Devinder K Rajput"
Date:
Subject: Re: NewBie