From: MirrorX <mirrorx@gmail.com>
To: pgsql-performance@postgresql.org
Subject: parse - bind take more time than execute
Date: Tue, 27 Dec 2011 02:52:13 -0800 (PST)
Message-ID: <1324983133749-5102940.post@n5.nabble.com> (raw)
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.htm...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mirrorx@gmail.com
Subject: Re: parse - bind take more time than execute
In-Reply-To: <1324983133749-5102940.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox