Re: GIST and TOAST

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: <andrew(at)supernews(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIST and TOAST
Date: 2007-03-06 16:31:45
Message-ID: 87wt1u9vv2.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Gregory Stark" <stark(at)enterprisedb(dot)com> writes:

> "Andrew - Supernews" <andrew+nonews(at)supernews(dot)com> writes:
>
>> So I think you've mis-analyzed the problem. That's especially true since
>> you are claiming that the existing code is already buggy when in fact no
>> such bugs have been reported (and clearly intarray has been running with
>> toasted array values for years).
>
> I'm not claiming, I'm asking, because I can't tell.
>
> And it's not clear _int_gist.c has been running with toasted array values for
> years because it's limited to arrays of 100 integers (or perhaps 200 integers,
> there's a factor of 2 in the test). That's not enough to trigger toasting
> unless there are other large columns in the same table.

Actually I just realized the other large columns in the table would be
irrelevant. It's not whether it's toasted in the table that matters, only if
it gets compressed by index_form_tuple that does. And it can't since 400 bytes
isn't large enough to trigger compression. Unless someone's using multi-column
intarray gist indexes with very large arrays which I'm not convinced anyone
is.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nik 2007-03-06 16:33:13 No buffer space available
Previous Message David Fetter 2007-03-06 16:27:48 Re: PostgreSQL - 'SKYLINE OF' clause added!