Re: vacuum full seems to hang on very small table - Mailing list pgsql-performance

From Simon Riggs
Subject Re: vacuum full seems to hang on very small table
Date
Msg-id 1144164914.13549.502.camel@localhost.localdomain
Whole thread Raw
In response to vacuum full seems to hang on very small table  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-performance
On Tue, 2006-04-04 at 08:59 -0600, Dan Harris wrote:
> I have a table with 1 live row that I found has 115000 dead rows in it (
> from a testing run ).  I'm trying to VACUUM FULL the table and it has
> run for over 18 hours without completion.  Considering the hardware on
> this box and the fact that performance seems reasonable in all other
> aspects, I'm confused as to why this would happen.  The database other
> than this table is quite large ( 70 gigs on disk ) and I would expect to
> take days to complete but I just did 'vacuum full table_stats'.  That
> should only do that table, correct?  I'm running 8.0.3.

Read this http://www.postgresql.org/docs/8.0/static/release-8-0-5.html
and you'll probably decide to upgrade.

Best Regards, Simon Riggs


pgsql-performance by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: vacuum full seems to hang on very small table
Next
From: "Mike Quinn"
Date:
Subject: Re: The order of fields around the "=" in the WHERE