pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM problems with 7.4
Date: Mon, 24 Nov 2003 12:44:30 -0500
Message-ID: <21399.1069695870@sss.pgh.pa.us> (raw)
In-Reply-To: <200311242243.59296.mallah@trade-india.com>
References: <200311242243.59296.mallah@trade-india.com>

Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> I am sure there is no transaction open with the table banner_stats2.
> Still VACUUM FULL does not  seems to effective in removing the
> dead rows.

That is not the issue --- the limiting factor is what is your oldest
open transaction, period.  Whether it has yet looked at this table is
not relevant, because the system has no way to know whether it might
decide to do so later.

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <21399.1069695870@sss.pgh.pa.us>
Permalink:  ../21399.1069695870@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/21399.1069695870@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mallah@trade-india.com
  Subject: Re: VACUUM problems with 7.4
  In-Reply-To: <21399.1069695870@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox