Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Date
Msg-id 20227.1208061832@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
Responses Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
List pgsql-general
Tree view 
"Paragon" <lr@pcorp.us> writes:
> I am running into problems vacuuming my larger tables.  It seems for tables
> greater than 1 million rows, Vacuum just hangs.  I could leave it running
> for hours and it never comes to completion.

Is it actually *doing* anything, like consuming CPU or I/O -- and if so
which?  How much does VACUUM VERBOSE print before getting stuck?

> vmstat shows

vmstat without any arguments is very nearly useless, because what it
shows you is averages since system boot.  Watch "vmstat 1" for awhile
and you will get an actual picture of what's happening.

            regards, tom lane

pgsql-general by date:

Previous
From: "Paragon"
Date:
Subject: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Next
From: "Paragon"
Date:
Subject: Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables