Re: Persistent Plan Cache - Mailing list pgsql-performance

From Joshua Rubin
Subject Re: Persistent Plan Cache
Date
Msg-id 4AAD36A8.8000502@esoft.com
Whole thread Raw
In response to Re: Persistent Plan Cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Persistent Plan Cache  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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


Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORMANCE] work_mem vs temp files issue
Next
From: Heikki Linnakangas
Date:
Subject: Re: Persistent Plan Cache