Re: Caching of Queries - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: Caching of Queries
Date
Msg-id 41528EC5.8030901@bigfoot.com
Whole thread Raw
In response to Re: Caching of Queries  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
Neil Conway wrote:
> Another idea would be to improve the quality of the plan we generate at PREPARE time:
> for instance you could generate 'n' plans for various combinations of
> input parameters, and then choose the best query plan at EXECUTE time.
> It's a difficult problem to solve, however (consider multiple parameters
> to PREPARE, for example).

Do you mean store different plans for each different histogram segment ?

Regards
Gaetano Mendola


pgsql-performance by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: Caching of Queries
Next
From: Bruce Momjian
Date:
Subject: Re: O_DIRECT setting