| From: | David Steele <david(at)pgmasters(dot)net> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PATCH: Exclude unlogged tables from base backups |
| Date: | 2017-12-12 23:35:20 |
| Message-ID: | a6eaa71b-0859-f848-72c2-31d2d4744fe5@pgmasters.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 12/12/17 6:33 PM, Andres Freund wrote:
>
> On 2017-12-12 18:30:47 -0500, David Steele wrote:
>>> If we had a way to prevent relfilenode reuse across multiple checkpoints
>>> this'd be easier, although ALTER TABLE SET UNLOGGED still'd complicate.
>>
>> Or error the backup if there is wraparound?
>
> That seems entirely unacceptable to me. On a machine with lots of
> toasting etc going on an oid wraparound doesn't take a long time. We've
> only one oid counter for all tables, and relfilenodes are inferred from
> that ....
Fair enough. I'll think on it.
--
-David
david(at)pgmasters(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2017-12-12 23:44:29 | Re: Leftover reference to replacement selection 1 run case |
| Previous Message | Andres Freund | 2017-12-12 23:33:48 | Re: PATCH: Exclude unlogged tables from base backups |