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

Re: Why will vacuum not end?

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
Cc: 'Christopher Kings-Lynne' <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-20 13:14:00
Message-ID: 40852218.2050204@potentialtech.com (view raw or flat)
Thread:
Lists: pgsql-performance
Shea,Dan [CIS] wrote:
> 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(at)familyhealth(dot)com(dot)au]
> Sent: Tuesday, April 20, 2004 12:02 AM
> To: Shea,Dan [CIS]
> Cc: pgsql-performance(at)postgresql(dot)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?

This may be a dumb question (but only because I don't know the answer)

Doesn't/shouldn't vacuum have some kind of timeout so if a table is locked
it will give up eventually (loudly complaining when it does so)?

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com


In response to

pgsql-performance by date

Next:From: Matt ClarkDate: 2004-04-20 13:44:40
Subject: Re: Wierd context-switching issue on Xeon
Previous:From: Dave CramerDate: 2004-04-20 13:06:59
Subject: Re: Wierd context-switching issue on Xeon

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