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 4085CDC3.4090201@familyhealth.com.au
Whole thread Raw
In response to Re: Why will vacuum not end?  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
List pgsql-performance
Tree view 
> No, but data is constantly being inserted by userid scores.  It is postgres
> runnimg the vacuum.
> Dan.

Well, inserts create some locks - perhaps that's the problem...

Otherwise, check the pg_locks view to see if you can figure it out.

Chris

pgsql-performance by date:

Previous
From: "J. Andrew Rogers"
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Josh Berkus
Date:
Subject: Re: Wierd context-switching issue on Xeon