[PERFORM] Odd misprediction

2011-09-16 Thread Claudio Freire
It's not an issue for me (it's not really impacting performance), but since it was odd I thought I might ask. I have this supermegaquery: SELECT t.date AS status_date, lu.id AS memberid, lu.username AS username, u.url AS url, ub.url_pattern AS urlpattern, lu.email AS email, lu.birth

Re: [PERFORM] Hash index use presently(?) discouraged since 2005: revive or bury it?

2011-09-16 Thread Stefan Keller
2011/9/16 Tom Lane : > I'm not entirely following this eagerness to junk that AM, anyway. > We've put a lot of sweat into it over the years, in the hopes that > it would eventually be good for something.  It's on the edge of > being good for something now, and there's doubtless room for more > impr

Re: [PERFORM] Hash index use presently(?) discouraged since 2005: revive or bury it?

2011-09-16 Thread Tomas Vondra
Dne 15.9.2011 01:40, Tom Lane napsal(a): > Stefan Keller writes: >> 2011/9/14 Tom Lane 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 i

Re: [PERFORM] Odd misprediction

2011-09-16 Thread Marti Raudsepp
On Fri, Sep 16, 2011 at 17:50, Claudio Freire wrote: > It's not an issue for me (it's not really impacting performance), but > since it was odd I thought I might ask. > > I have this supermegaquery: > > SELECT >       t.date AS status_date, lu.id AS memberid, lu.username AS > username, u.url AS ur