Re: Why does a simple query not use an obvious index?

From: Mr Pink <mr_pink_is_the_only_pro(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why does a simple query not use an obvious index?
Date: 2004-08-30 07:38:41
Message-ID: 20040830073841.30957.qmail@web41108.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guy Thornley 2004-08-30 08:19:59 Re: Why does a simple query not use an obvious index?
Previous Message Tom Lane 2004-08-30 02:23:56 Re: Why does a simple query not use an obvious index?