Skip site navigation (1) Skip section navigation (2)

Re: Why will vacuum not end?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-21 01:26:27
Message-ID: 4085CDC3.4090201@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
> 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


In response to

pgsql-performance by date

Next:From: Aaron WermanDate: 2004-04-21 02:14:51
Subject: Re: Moving postgres to FC disks
Previous:From: Paul TuckfieldDate: 2004-04-21 00:34:13
Subject: Re: Wierd context-switching issue on Xeon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group