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

Re: vacuum problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John R Pierce" <pierce(at)hogranch(dot)com>
Cc: "pgsql -bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: vacuum problem
Date: 2004-09-11 16:05:18
Message-ID: 11187.1094918718@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"John R Pierce" <pierce(at)hogranch(dot)com> writes:
>> You've got some background client holding a transaction open.  Or else
>> the test program isn't really committing when you think it is.

> there are no background programs.  I've done all the usual checking of `ps' 
> outputs looking for such.

> in the test case I mailed to this list, I had created a standalone database 
> with one table, and run the test program directly against it.

That sounds suspiciously like you think that only background clients
connected to the same database count.  Actually, any other client
connected to the same *postmaster* can look like an open transaction
to VACUUM ...

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2004-09-11 16:42:51
Subject: Re: 8.0 beta service won't start
Previous:From: Estevan RechDate: 2004-09-11 15:05:55
Subject: help in installation

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