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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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