Postgres Pro
Downloads
Home   >   mailing lists

Re: Why will vacuum not end? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Why will vacuum not end?
Date
Msg-id 4084A0D0.5060305@familyhealth.com.au
Whole thread Raw
In response to Why will vacuum not end?  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
List pgsql-performance
Tree view 
> This vacuum is running  a marathon.  Why will it not end and show me free
> space map INFO?  We have deleted a lot of data and I would like to be
> confident that these deletions will be used as free space, rather than
> creating more table files.

Does another postgres query running have a lock on that table?

Chris

pgsql-performance by date:

Previous
From: Robert Creager
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: jelle
Date:
Subject: Re: Wierd context-switching issue on Xeon