| 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: | Whole Thread | Raw Message | 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 |