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

From Shea,Dan [CIS]
Subject Re: Why will vacuum not end?
Date
Msg-id F2D63B916C88C14D9B59F93C2A5DD33F0B923F@cisxa.cmc.int.ec.gc.ca
Whole thread Raw
In response to Why will vacuum not end?  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
Responses Re: Why will vacuum not end?  (Bill Moran <wmoran@potentialtech.com>)
Re: Why will vacuum not end?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
No, but data is constantly being inserted by userid scores.  It is postgres
runnimg the vacuum.
Dan.

-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
Sent: Tuesday, April 20, 2004 12:02 AM
To: Shea,Dan [CIS]
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Why will vacuum not end?


> 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: Jeff
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Dave Cramer
Date:
Subject: Re: Wierd context-switching issue on Xeon