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-20 04:02:24
Message-ID: 4084A0D0.5060305@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message jelle 2004-04-20 05:18:21 Re: Wierd context-switching issue on Xeon
Previous Message Robert Creager 2004-04-20 03:47:02 Re: Wierd context-switching issue on Xeon