Re: Persistent Plan Cache

From: Joshua Rubin <jrubin(at)esoft(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Persistent Plan Cache
Date: 2009-09-13 18:15:04
Message-ID: 4AAD36A8.8000502@esoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

> If you're depending on constraint exclusion, it's hard to see how plan
> caching could help you at all. The generated plan needs to vary
> depending on the actual WHERE-clause parameters.

Thank you for the reply.

We "hardcode" the parts of the where clause so that the prepared plan
will not vary among the possible partitions of the table. The only
values that are bound would not affect the planner's choice of table.

Thanks,
Joshua

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-09-13 19:21:31 Re: possible wrong query plan on pg 8.3.5,
Previous Message Tom Lane 2009-09-13 17:45:25 Re: Persistent Plan Cache