Skip site navigation (1) Skip section navigation (2)

Re: Caching of Queries

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: Caching of Queries
Date: 2004-09-23 08:52:21
Message-ID: 41528EC5.8030901@bigfoot.com (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-performance by date

Next:From: Bruce MomjianDate: 2004-09-23 13:35:45
Subject: Re: O_DIRECT setting
Previous:From: Gary DoadesDate: 2004-09-23 06:36:11
Subject: Re: Caching of Queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group