From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [BUGS] Breakage with VACUUM ANALYSE + partitions |
Date: | 2016-05-02 22:14:19 |
Message-ID: | 20160502221419.shvm4vuhi4jh5hoe@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Hi,
On 2016-05-03 00:05:35 +0200, Fabien COELHO wrote:
> Maybe consider checking for the exclusivity explicitely?
I thought about it, and decided it's not worth it. Requiring one of
those to be specified seems stringent enough.
> I'm unsure about switching enum to #define, could be an enum still with
> explicit values set, something like:
>
> enum {
> EXTENSION_RETURN_NULL = (1 << 0),
> ...
> } extension_behavior;
An enum doesn't have a benefit for a bitmask imo - you can't "legally"
use it as a type for functions accepting the bitmask.
> I'm fuzzy about the _OPEN_DELETED part because it is an oxymoron. Is it
> RECREATE really?
No. The relevant explanation is at the top of the file:
* On disk, a relation must consist of consecutively numbered segment
* files in the pattern
* -- Zero or more full segments of exactly RELSEG_SIZE blocks each
* -- Exactly one partial segment of size 0 <= size < RELSEG_SIZE blocks
* -- Optionally, any number of inactive segments of size 0 blocks.
* The full and partial segments are collectively the "active" segments.
* Inactive segments are those that once contained data but are currently
* not needed because of an mdtruncate() operation. The reason for leaving
* them present at size zero, rather than unlinking them, is that other
* backends and/or the checkpointer might be holding open file references to
* such segments. If the relation expands again after mdtruncate(), such
* that a deactivated segment becomes active again, it is important that
* such file references still be valid --- else data might get written
* out to an unlinked old copy of a segment file that will eventually
* disappear.
- Andres
From | Date | Subject | |
---|---|---|---|
Next Message | targen | 2016-05-02 22:37:20 | BUG #14124: ON UPDATE CASCADE failure on repeated foreign key column |
Previous Message | Fabien COELHO | 2016-05-02 22:05:35 | Re: [BUGS] Breakage with VACUUM ANALYSE + partitions |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-05-02 23:17:42 | Re: Is pg_control file crashsafe? |
Previous Message | Fabien COELHO | 2016-05-02 22:05:35 | Re: [BUGS] Breakage with VACUUM ANALYSE + partitions |