Re: WIP: Fast GiST index build - Mailing list pgsql-hackers

From Robert Haas
Subject Re: WIP: Fast GiST index build
Date
Msg-id CA+TgmoZfW9CZF_VQKxhcP4pGA0+ezAxmY3OufH82sY4iVATx2Q@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Fast GiST index build  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-hackers
On Tue, Sep 13, 2011 at 5:00 PM, Stefan Keller <sfkeller@gmail.com> wrote:
> 2011/9/6 Alexander Korotkov <aekorotkov@gmail.com>:
>> GiST use serial numbers of operations for concurrency. In current
>> implementation xlog record ids are used in capacity of that numbers. In
>> unlogged table no xlog records are produced. So, we haven't serial numbers
>> of operations. AFAIK, it's enough to provide some other source of serial
>> number in order to make GiST work with unlogged tables.
>
> GiST is IMHO quite broadly used. I use it for example for indexing
> geometry and hstore types and there's no other choice there.
> Do you know whether unlogged option in create table will support GiST
> in the next release?

It's probably not a difficult patch to write, but I don't have any
current plans to work on it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: augmenting MultiXacts to improve foreign keys
Next
From: Hannu Krosing
Date:
Subject: Re: What Would You Like To Do?