| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Dan Harris <fbsd(at)drivefaster(dot)net> |
| Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: vacuum full seems to hang on very small table |
| Date: | 2006-04-04 15:35:14 |
| Message-ID: | 1144164914.13549.502.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Quinn | 2006-04-04 17:18:30 | Re: The order of fields around the "=" in the WHERE |
| Previous Message | Brad Nicholson | 2006-04-04 15:07:51 | Re: vacuum full seems to hang on very small table |