Re: Poor plan choice in prepared statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 1 Jan 2009, Guillaume Smet wrote:

On Thu, Jan 1, 2009 at 9:24 PM,  <david@xxxxxxx> wrote:
forgive my ignorance here, but if it's unnamed how can you reference it
later to take advantage of the parsing?

You can't. That's what unnamed prepared statements are for.

It's not obvious to me that the parsing phase is worth any "caching".
From my experience, the planning phase takes far much time on complex
queries.

the poster who started this thread had a query where the parsing phase took significantly longer than the planning stage.

David Lang

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux