Postgres Pro
Downloads
Home   >   mailing lists

Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Any better plan for this query?..
Date
Msg-id 4A09050C.4080009@enterprisedb.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
Responses Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
List pgsql-performance
Tree view 
Dimitri wrote:
> Now, as you see from your explanation, the Part #2 is the most
> dominant - so why instead to blame this query not to implement a QUERY
> PLANNER CACHE??? - in way if any *similar* query is recognized by
> parser we simply *reuse* the same plan?..

At least in JDBC, there's several open source prepared statement cache
implementations out there that people use. I don't know about other
client libraries, but it certainly is possible to do in the client.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Next
From: Dimitri
Date:
Subject: Re: Any better plan for this query?..