Re: Cluster and vacuum performance

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Cluster and vacuum performance
Date: 2004-03-10 17:35:47
Message-ID: 200403100935.47299.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

> You misread it --- "nonremovable" doesn't mean "dead but not removable",
> it just means "not removable". Actually the next line of his log showed
> there were zero nonremovable dead tuples, so he's not got any
> open-transaction problem.

Ooops. Sorry, Dan.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2004-03-10 17:51:18 Re: optimizing large query with IN (...)
Previous Message Steve Atkins 2004-03-10 17:11:04 Re: optimizing large query with IN (...)