From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Crash in gist insertion on pathological box data |
Date: | 2009-04-03 15:38:03 |
Message-ID: | 12519.1238773083@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
>> Here is a test case that crashes even with the patch:
> I was too optimistic :(
> Attached patch contains:
> - changes in R-tree picksplit methods. Now it checks bad ratio and if so then
> use simple split: one half of entries to one page, and another part - to
> another page.
> - protection from buggy picksplit method: GiST will emit an error if picksplit
> of first column has that bug. For second and next column it could be a desired
> behaviour, because picksplit may take in attention result of picksplit of
> previous column.
I don't like throwing an error there; I wish there were a way for the
generic code to apply the fallbackSplit code instead. I see that
in this particular formulation it's dependent on the datatype ---
can we get around that, by having it invoke the union method?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Helmle | 2009-04-03 15:39:30 | Re: Documentation Update: Document pg_start_backup checkpoint behavior |
Previous Message | Lawrence, Ramon | 2009-04-03 15:24:12 | Re: a few crazy ideas about hash joins |