Re: WAL logging of hash indexes - Mailing list pgsql-hackers

From Kenneth Marshall
Subject Re: WAL logging of hash indexes
Date
Msg-id 20080116151420.GO4201@it.is.rice.edu
Whole thread Raw
In response to WAL logging of hash indexes  ("John Smith" <sodgodofall@gmail.com>)
List pgsql-hackers
On Tue, Jan 15, 2008 at 07:18:17PM -0800, John Smith wrote:
> http://archives.postgresql.org/pgsql-hackers/2007-10/msg01468.php,
> 
> "... I very much want to encourage authors of new Resource Managers and it
> looks like we may be getting at least 3 new RMs that produce WAL
> records: hash indexes (currently not WAL-logged), bitmap indexes and
> clustered indexes for 8.4. We should be realistic that new bugs probably
> will occur in recovery code for existing and new RMs."
> 
> 
> 
> Can someone clarify if WAL-logging of hash indexes will be supported
> in the 8.4 release?
> 
> - John
> 
John,

You can check the mailing list archives to follow recent discussions
about addressing the performance problems of hash indexes in PostgreSQL.
I think that we have some good ideas that may pan out. If the performance
problems can be fixed, it is my goal to have support for WAL logged,
unique hash indexes ready for 8.4. But as the thread describes, we need
the performance first or doing the rest makes no sense if btree indexes
work better.

Cheers,
Ken


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: to_char incompatibility
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Password policy