Re: parse - bind take more time than execute

Поиск
Список
Период
Сортировка
От MirrorX
Тема Re: parse - bind take more time than execute
Дата
Msg-id 1324992867448-5103116.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: parse - bind take more time than execute  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: Re: parse - bind take more time than execute
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: parse - bind take more time than execute