Re: parse - bind take more time than execute - Mailing list pgsql-performance

From MirrorX
Subject Re: parse - bind take more time than execute
Date
Msg-id 1324992867448-5103116.post@n5.nabble.com
Whole thread Raw
In response to Re: parse - bind take more time than execute  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-performance
thx a lot for your answer :)

2) default_statistics_target is set to (default) 100 and there no special
statistics per-column

3) i will do that very soon

4) in absolute units i can see the same query having similar stats to these:
parse -> 600 ms
bind -> 300 ms
execute -> 50 ms

the query mentioned above is a simple select from one table using using two
where conditions. and this table has 1 additional index (except the primary
key) on the columns that are part of the where clause

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/parse-bind-take-more-time-than-execute-tp5102940p5103116.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: parse - bind take more time than execute
Next
From: Pavel Stehule
Date:
Subject: Re: parse - bind take more time than execute