Re: parse - bind take more time than execute

Hello

2011/12/27 MirrorX <mirrorx@gmail.com>:
> there are some performance issues on a server and by searching in the logs i
> noticed that the phases of parse and bind take considerably more time than
> execute for most of the queries. i guess that the right thing to do in this
> case is to use functions or prepare statements but in any case, what could
> be the cause of this?
>

A reason should be a blind optimization of prepared statement.
Prepared statements are optimized to most frequent values.

try to look on plan - statement EXPLAIN should be used for prepared
statements too.

Regards

Pavel Stehule

> information about the server->
> -CentOS 5.6
> -4-cores
> -12GB ram
>
>
> shared_buffers: 1 GB
> temp_buffers = 100MB
> work_mem : 30 MB
> maintenance_mem: 512 MB
>
> database_size: 1,5 GB
> archive_mode is ON
> vacuum/analyze (vacuum_scale_factor 0.1, analyze 0.05)
>
>
> this behaviour is not related with checkpoints on the database (as indicated
> by the logs, i dont see this latency when a checkpoint occurs, i see it most
> of the time)
>
> so my question is the following; what can cause the bind/parse phases to
> take so much longer than the execute? if you need any more info the server i
> ll be glad to provide it. thank you in advance for your advice
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/parse-bind-take-more-time-than-execute-tp5102940p5102940.html
> Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance