Re: [HACKERS] GSoC on WAL-logging hash indexes

From: Greg Stark <stark(at)mit(dot)edu>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tan Tran <tankimtran(at)gmail(dot)com>, pgsql-advocacy <pgsql-advocacy(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] GSoC on WAL-logging hash indexes
Date: 2014-03-06 02:03:11
Message-ID: CAM-w4HNGN+eyDzZEaZB_XHLfMCGMqZNZ+2GJpty+PdrDEtzeWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-students

On Mon, Mar 3, 2014 at 4:12 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> Unfortunately, I don't believe that it's possible to do this easily
> today because of the way bucket splits are handled. I wrote about
> this previously here, with an idea for solving the problem:

We could just tackle this in the same incomplete, buggy, way that
btrees tackled it for years until Heikki fixed them and the way gin
and gist still do I believe. Namely just emit xlog records for each
page individually and during replay remember when you have an
"incomplete split" and complain if recovery ends with any still
incomplete. That would be unfortunate to be adding new cases of this
just as Heikki and company are making progress eliminating the ones we
already had but that's surely better than having no recovery at all.

--
greg

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Heikki Linnakangas 2014-03-06 13:11:04 Re: GSoC on WAL-logging hash indexes
Previous Message Jonathan S. Katz 2014-03-05 20:31:39 Re: [pgsql-advocacy] PostgreSQL User Group in Singapore

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Pflug 2014-03-06 02:19:31 Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Previous Message Craig Ringer 2014-03-06 01:56:24 Re: Row-security on updatable s.b. views

Browse pgsql-students by date

  From Date Subject
Next Message Heikki Linnakangas 2014-03-06 13:11:04 Re: GSoC on WAL-logging hash indexes
Previous Message Jeff Janes 2014-03-05 20:19:27 Re: [HACKERS] GSoC on WAL-logging hash indexes