Re: Partial index where clause not filtering through

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)nasby(dot)net
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Partial index where clause not filtering through
Date: 2003-06-16 22:39:24
Message-ID: 7288.1055803164@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> Also, I just read that there's no statement plan caching, which makes me
> a bit confused by this todo:
> Flush cached query plans when their underlying catalog data changes
> Does that only apply to pl/pgsql?

That and PREPARE.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2003-06-16 22:41:05 Re: left join performance problem
Previous Message Jim C. Nasby 2003-06-16 22:32:09 Re: Partial index where clause not filtering through