| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: autovacuum and TOAST tables |
| Date: | 2008-10-09 22:17:05 |
| Message-ID: | 20081009221705.GF11121@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > I wonder if we can get away with simply renaming the new toast table and
> > index after the data has been copied.
>
> Yeah, that seems like the best answer.
Seems like this patch fixes it.
How far back should be backpatched? Given the lack of field complaints
I'd say "just to HEAD" but maybe others have different opinions. FWIW
the patch applies cleanly (modulo header changes) back to 8.0.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| Attachment | Content-Type | Size |
|---|---|---|
| cluster-toastname.patch | text/x-diff | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-09 22:23:46 | pgsql: Un-break non-NLS builds. |
| Previous Message | Grzegorz Jaskiewicz | 2008-10-09 22:08:27 | Re: head's linking problem |