Thread: Caching query plan...

Was wondering if something is worked to get a pool of cached query plan in
Postgresql ?
the topic [cached query plan] on the TODO list is a bit out of date and i
believe this feature could decently improve performance.

> Was wondering if something is worked to get a pool of cached query plan in
> Postgresql ?
> the topic [cached query plan] on the TODO list is a bit out of date and i
> believe this feature could decently improve performance.

We haven't gone any farther than what you see in the TODO list detail.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Christian Meunier wrote:

> Was wondering if something is worked to get a pool of cached query plan in
> Postgresql ?
> the topic [cached query plan] on the TODO list is a bit out of date and i
> believe this feature could decently improve performance.

Also it would be nice to se the use of "prepared statements" and "host
arrays" in the PG API, as these are the key to optimal use of "cached query
plans", and is supported in several SQL interfaces (JDBC).

/BL

En un mensaje anterior, Christian Meunier escribió:
> Was wondering if something is worked to get a pool of cached query plan in
> Postgresql ?
> the topic [cached query plan] on the TODO list is a bit out of date and i
> believe this feature could decently improve performance.

Some guys on my university made an implementation of cached query
plans on Postgres as they degree thesis. I don't know the details,
but if there is interest I might be able to contact them (they might
be already reading this list, OTOH...)

Regards


Fernando P. Schapachnik
Gerente de tecnología de red
y sistemas de información
VIA NET.WORKS ARGENTINA S.A.
fschapachnik@vianetworks.com.ar
Tel.: (54-11) 4323-3381