| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | "Jan Wieck" <wieck(at)hub(dot)org>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql/src/backend/commands (command.c vacuum.c) |
| Date: | 2000-12-09 15:52:05 |
| Message-ID: | 11350.976377125@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
>> Special handling of TOAST relations during VACUUM. TOAST relations
>> are vacuumed while the lock on the master table is still active.
> It seems very dangerous to me.
> When VACUUM of a master table was finished, the transaction is
> in already committed state in many cases.
I don't see the problem. If the toast table doesn't get vacuumed,
no real harm is done other than failing to recover space.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | momjian | 2000-12-09 15:52:11 | pgsql/contrib/fulltextindex (TODO) |
| Previous Message | Hiroshi Inoue | 2000-12-09 13:23:22 | RE: pgsql/src/backend/commands (command.c vacuum.c) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2000-12-09 16:03:17 | Re: |
| Previous Message | Tom Lane | 2000-12-09 15:45:33 | Re: |