| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUM and transactions in different databases |
| Date: | 2006-12-07 16:28:30 |
| Message-ID: | 16006.1165508910@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> In response to Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>> Of course they are able to complete, but the point is that they would
>> not remove the tuples that would be visible to that idle open
>> transaction.
> I would expect that, but the OP claimed that vacuum full waited until
> the other transaction was finished.
No, she didn't claim that. As far as I see she was just complaining
about the failure to remove dead tuples:
> > > > If I have a running transaction in database1 and try to vacuum
> > > > database2 but the dead tuples in database2 cannot be removed.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Angva | 2006-12-07 16:38:06 | loading data, creating indexes, clustering, vacuum... |
| Previous Message | David Goodenough | 2006-12-07 16:19:13 | Performance figures from DbMail list |