Re: WIP: Fast GiST index build
Stefan Keller <sfkeller@gmail.com>
From: Stefan Keller <sfkeller@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-09-14T06:43:33Z
Lists: pgsql-hackers
I'm on the way to open a ticket for hash indexes (adding WAL support) anyway: May I open a ticket for adding GiST support to unlogged tables ? Stefan 2011/9/14 Stefan Keller <sfkeller@gmail.com>: > Robert, > > 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? > > Stefan >