| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2004-09-11 16:42:51 | Re: 8.0 beta service won't start |
| Previous Message | Estevan Rech | 2004-09-11 15:05:55 | help in installation |