parse - bind take more time than execute

From: MirrorX <mirrorx(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: parse - bind take more time than execute
Date: 2011-12-27 10:52:13
Message-ID: 1324983133749-5102940.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MirrorX 2011-12-27 11:01:59 Re: parse - bind take more time than execute
Previous Message Pavel Stehule 2011-12-27 09:38:18 Re: How to clock the time spent for query parsing and planning?