No, but data is constantly being inserted by userid scores. It is postgres runnimg the vacuum. Dan.
-----Original Message----- From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 12:02 AM To: Shea,Dan [CIS] Cc: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html