| From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
|---|---|
| To: | Stefan Keller <sfkeller(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WIP: Fast GiST index build |
| Date: | 2011-09-06 13:51:50 |
| Message-ID: | CAPpHfdvDDk-7TfHy4HjRWcjJNTJqPAjzXPKJeKZzLf4QkC6Smw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi!
> Unlogged tables seems to me to follow a similar goal. Obviously GiST
> indexes are not supported there.
> Do you know the technical reason?
>
GiST using 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.
> Do you see some synergy in your work on fast GiST index building and
> unlogged tables?
>
With tecnhique discussing in this thread GiST build can win form unlogged as
much as with regular build.
------
With best regards,
Alexander Korotkov.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-09-06 14:01:37 | Re: Rectifying wrong Date outputs |
| Previous Message | Robert Haas | 2011-09-06 13:49:39 | Re: B-tree parent pointer and checkpoints |