Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Antonin Houska
Tom Lane wrote: > Alvaro Herrera writes: > > Tom Lane wrote: > >> Not that I've heard of. It's very hard to muster any enthusiasm for > >> improving hash indexes unless their lack of WAL-logging is fixed first. > > > This is really strange though. Surely adding WAL-logging is not an > > enorm

Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Andreas Karlsson
On 02/04/2016 11:34 PM, Tom Lane wrote: Alvaro Herrera writes: This is really strange though. Surely adding WAL-logging is not an enormous task anymore ... I mean, we're undertaking far larger efforts now, the WAL logging code is simpler than before, and we even have a tool (ok, gotta streamli

Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane wrote: >> Not that I've heard of. It's very hard to muster any enthusiasm for >> improving hash indexes unless their lack of WAL-logging is fixed first. > This is really strange though. Surely adding WAL-logging is not an > enormous task anymore ... I mean, we'

Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Alvaro Herrera
Tom Lane wrote: > Shubham Barai writes: > > I wanted to know if anyone is working on these projects from todo list. > > 1.Add UNIQUE capability to hash indexes > > 2.Allow multi-column hash indexes > > Not that I've heard of. It's very hard to muster any enthusiasm for > improving hash indexes u

Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread David Steele
On 2/4/16 1:12 PM, Tom Lane wrote: > Shubham Barai writes: >> I wanted to know if anyone is working on these projects from todo list. >> 1.Add UNIQUE capability to hash indexes >> 2.Allow multi-column hash indexes > > Not that I've heard of. It's very hard to muster any enthusiasm for > improvin

Re: [HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Tom Lane
Shubham Barai writes: > I wanted to know if anyone is working on these projects from todo list. > 1.Add UNIQUE capability to hash indexes > 2.Allow multi-column hash indexes Not that I've heard of. It's very hard to muster any enthusiasm for improving hash indexes unless their lack of WAL-loggin

[HACKERS] UNIQUE capability to hash indexes

2016-02-04 Thread Shubham Barai
Hello hackers , I wanted to know if anyone is working on these projects from todo list. 1.Add UNIQUE capability to hash indexes 2.Allow multi-column hash indexes I couldn't find any discussion about these projects. Thanks, Shubham Barai