| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | Joe Conway <mail(at)joeconway(dot)com>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: crash on 8.2 and cvshead - failed to add item to the |
| Date: | 2007-01-26 15:05:10 |
| Message-ID: | 23777.1169823910@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> Tom Lane wrote:
>> I'm still wondering why the bug isn't seen in 8.1.
> The hardcoded fillfactor was 90% when building an index, and that's
> still the default. However, when inserting to an existing index, the
> fillfactor on the rightmost page was 2/3. It was changed to use the
> user-configurable fillfactor, which now defaults to 90%.
Ah. I thought I remembered that those had been two separate changes,
but you're right, 8.1 and before always split 1:1 or 2:1. So it'd take
a really nasty corner case to expose the bug there.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-01-26 15:10:56 | Re: Proposal: Commit timestamp |
| Previous Message | Stephen Frost | 2007-01-26 14:38:49 | Re: Proposal: Commit timestamp |