From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stefan Keller <sfkeller@gmail.com>
Cc: Peter Geoghegan <peter@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Date: Wed, 14 Sep 2011 19:40:18 -0400
Message-ID: <8905.1316043618@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFcOn29Ev0FgCZniiDaHUiW7JZiVyYrH5v9bnm_dbVycuxs4MA@mail.gmail.com>
References: <CAFcOn293Rzi7cZYWBT8tjxCtNX5pYdbknANXgf9mWfBizK8Frg@mail.gmail.com>
<CAEYLb_Udue8_XSE9K0KMqKBE_62yurv1bY4Wc+qJoGykZ_rXtA@mail.gmail.com>
<16096.1315959870@sss.pgh.pa.us>
<CAFcOn29Ev0FgCZniiDaHUiW7JZiVyYrH5v9bnm_dbVycuxs4MA@mail.gmail.com>
Stefan Keller <sfkeller@gmail.com> writes:
> 2011/9/14 Tom Lane <tgl@sss.pgh.pa.us> writes:
>> (...) I think that
>> the current state of affairs is still what depesz said, namely that
>> there might be cases where they'd be a win to use, except the lack of
>> WAL support is a killer. I imagine somebody will step up and do that
>> eventually.
> How much of work (in man days) do you estimate would this mean for
> someone who can program but has to learn PG internals first?
No idea ... I'm probably not the best person to estimate how long it
would take someone to get up to speed on the relevant internals,
but I'm sure that would take longer than actually doing the work.
While it's not a trivial task, I think it fits the definition of
"a small matter of programming": a piece of code whose anticipated
length is significantly greater than its complexity.
regards, tom lane
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, sfkeller@gmail.com, peter@2ndquadrant.com
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
In-Reply-To: <8905.1316043618@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