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

Re: Why will vacuum not end?

From: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
To: 'Christopher Kings-Lynne' <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why will vacuum not end?
Date: 2004-04-20 12:58:09
Message-ID: F2D63B916C88C14D9B59F93C2A5DD33F0B923F@cisxa.cmc.int.ec.gc.ca (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.

-----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?

Chris

Responses

pgsql-performance by date

Next:From: Dave CramerDate: 2004-04-20 13:06:59
Subject: Re: Wierd context-switching issue on Xeon
Previous:From: JeffDate: 2004-04-20 12:46:12
Subject: Re: Wierd context-switching issue on Xeon

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