important Re: [HACKERS] Open 6.5 items - Mailing list pgsql-hackers

From ZEUGSWETTER Andreas IZ5
Subject important Re: [HACKERS] Open 6.5 items
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B388@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: important Re: [HACKERS] Open 6.5 items
List pgsql-hackers
    Hiroshi wrote:
> Ole Gjerde who provided the patch for current implementation of 
> mdtruncate() sayz.
> "First, please reverse my patch to mdtruncate() in md.c as soon as
>  possible.  It does not work properly in some cases."
> 
> I also recommend to reverse his patch to mdtruncate().
> 
> Though we could not shrink segmented relations by old implementation 
> the result by vacuum would never be inconsistent(?).
> 
> I think we don't have enough time to fix this.
> 
If there is no fix for vacuum, I suggest to change the filesize before
splitting
back to just below 2 Gb (2Gb - 8k). Else vacuum will only work for tables
up to 1 Gb, and it did work up to 2 Gb before.

I am the one who suggested 1 Gb, so I had my eye on this issue.
I still think 1 Gb is good for various reasons, but only if vacuum works.

Andreas


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Open 6.5 items
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Open 6.5 items