From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: store additional info in GIN index |
Date: | 2012-12-04 17:34:51 |
Message-ID: | CA+TgmobHoXGQB56MK6m0jH3_AtwrDKDmWgZUvrP_MmiuHVWQog@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Nov 18, 2012 at 4:54 PM, Alexander Korotkov
<aekorotkov(at)gmail(dot)com> wrote:
> Patch completely changes storage in posting lists and leaf pages of posting
> trees. It uses varbyte encoding for BlockNumber and OffsetNumber.
> BlockNumber are stored incremental in page. Additionally one bit of
> OffsetNumber is reserved for additional information NULL flag. To be able to
> find position in leaf data page quickly patch introduces small index in the
> end of page.
This sounds like it means that this would break pg_upgrade, about
which I'm not too keen. Ideally, we'd like to have a situation where
new indexes have additional capabilities, but old indexes are still
usable for things that they could do before. I am not sure whether
that's a realistic goal.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Scott | 2012-12-04 17:35:32 | Re: Slow query: bitmap scan troubles |
Previous Message | Robert Haas | 2012-12-04 17:32:26 | Re: Minor optimizations in lazy_scan_heap |