Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors
Date
Msg-id 8646.1355326620@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
Heikki Linnakangas <hlinnakangas@vmware.com> writes:
> The bug's been fixed now, but note that huge tuples like this will 
> always cause the table to be extended. Even if there are completely 
> empty pages in the table, after a vacuum. Even a completely empty 
> existing page is not considered spacious enough in this case, because 
> it's still too small when you take fillfactor into account, so the 
> insertion will always extend the table.

Seems like that's a bug in itself: there's no reason to reject an empty
existing page.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [BUG?] lag of minRecoveryPont in archive recovery
Next
From: Pavan Deolasee
Date:
Subject: Re: PageIsAllVisible()'s trustworthiness in Hot Standby