Re: prepared statements and partitioning (partition elimination not working)

От: Kenneth Marshall
Тема: Re: prepared statements and partitioning (partition elimination not working)
Дата: ,
Msg-id: 20100308173143.GD19562@it.is.rice.edu
(см: обсуждение, исходный текст)
Ответ на: prepared statements and partitioning (partition elimination not working)  (Kevin Kempter)
Список: pgsql-performance

On Mon, Mar 08, 2010 at 10:24:56AM -0700, Kevin Kempter wrote:
> Hi all;
>
> we've found that partition elimination is not happening for a prepared
> statement, however running the same statement in psql manually does give us
> partition elimination.
>
> Is this a known issue?
>

Yes, see the recent threads on performance of prepared queries.
It concerns the availability of information on the query inputs
that is available to psql and not a pre-prepared query.

Cheers,
Ken


В списке pgsql-performance по дате сообщения:

От: Simon Riggs
Дата:
Сообщение: Re: partition pruning
От: Scott Carey
Дата:
Сообщение: Re: 10K vs 15k rpm for analytics