pg.ddx.io  pgsql-students@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
Cc: Peter Geoghegan <pg@heroku.com>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tan Tran <tankimtran@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: GSoC on WAL-logging hash indexes
Date: Wed, 30 Apr 2014 17:41:57 -0400
Message-ID: <29533.1398894117@sss.pgh.pa.us> (raw)
In-Reply-To: <CAM-w4HPkFEWCXEcJ_=yhdceedGvRG_vS=mqsKcK+YBLyStQ8wQ@mail.gmail.com>
References: <B444B441-397F-4EDA-8A0C-877B9AF7033B@gmail.com>
	<54977A8C-4AF5-4BCC-B021-78E9CA978077@gmail.com>
	<CA+TgmoY4X7VKyC4dAwujuTuBoyxE2qSJF9aybhWZjxXWoc6J8w@mail.gmail.com>
	<CAM3SWZRBpAz=bZYCxvQDSGKR5OA5yEhGVOCit7AyStUtq2cBDA@mail.gmail.com>
	<CAMkU=1wYbPHnsab8EnkyawYrdBtt5kcrYSnHgKamU57ZBL5zyA@mail.gmail.com>
	<CAM3SWZR_Xmc=ZgRJdK-JRm7OxHvCUKgdL=DVNBOs1YxOTr-1Aw@mail.gmail.com>
	<CAM-w4HPkFEWCXEcJ_=yhdceedGvRG_vS=mqsKcK+YBLyStQ8wQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

Greg Stark <stark@mit.edu> writes:
> But imnsho doing nothing is a bad idea. We should have long ago either
> added WAL logging or removed the index type. We shouldn't have left a
> foot-gun that large lying around for so long.

We can't remove the hash index type, nor move it to an extension,
because it is the operator classes for the built-in hash index AM
that tell the planner and executor how to do hashing for arbitrary
datatypes.  And we certainly do not want to give up hashing-based
query plans, whatever you may think of hash indexes.

We really oughta fix the WAL situation, not just band-aid around it.

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (36+ messages)

Message-ID: <29533.1398894117@sss.pgh.pa.us>
Permalink:  ../29533.1398894117@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/29533.1398894117@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-students@postgresql.org
  Cc: tgl@sss.pgh.pa.us, stark@mit.edu, pg@heroku.com, jeff.janes@gmail.com, robertmhaas@gmail.com, tankimtran@gmail.com, pgsql-hackers@postgresql.org
  Subject: Re: GSoC on WAL-logging hash indexes
  In-Reply-To: <29533.1398894117@sss.pgh.pa.us>
  References: <B444B441-397F-4EDA-8A0C-877B9AF7033B@gmail.com> <54977A8C-4AF5-4BCC-B021-78E9CA978077@gmail.com> <CA+TgmoY4X7VKyC4dAwujuTuBoyxE2qSJF9aybhWZjxXWoc6J8w@mail.gmail.com> <CAM3SWZRBpAz=bZYCxvQDSGKR5OA5yEhGVOCit7AyStUtq2cBDA@mail.gmail.com> <CAMkU=1wYbPHnsab8EnkyawYrdBtt5kcrYSnHgKamU57ZBL5zyA@mail.gmail.com> <CAM3SWZR_Xmc=ZgRJdK-JRm7OxHvCUKgdL=DVNBOs1YxOTr-1Aw@mail.gmail.com> <CAM-w4HPkFEWCXEcJ_=yhdceedGvRG_vS=mqsKcK+YBLyStQ8wQ@mail.gmail.com> <29533.1398894117@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox