Re: Why does a simple query not use an obvious index? - Mailing list pgsql-performance

From Mr Pink
Subject Re: Why does a simple query not use an obvious index?
Date
Msg-id 20040830073841.30957.qmail@web41108.mail.yahoo.com
Whole thread Raw
In response to Re: Why does a simple query not use an obvious index?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why does a simple query not use an obvious index?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Yeah! Bind variable peeking is great news. I did actually read the guff, but forgot about that.

Version 8 is looking great on paper, I hope I'll get a chance to play wth it soon.

I can kind of appreciate your point about peeking stable functions, however, I would have thought
that if it was possible to do for bind variables (which could change many times in a transaction)
then it would make even more sense for a stable function which doesn't change for the life of the
transaction. No doubt this is an oversimplification the situation.

regards
Mr Pink



_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why does a simple query not use an obvious index?
Next
From: Guy Thornley
Date:
Subject: Re: Why does a simple query not use an obvious index?