Re: Explain Analyze returns faster than psql or JDBC calls.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Explain Analyze returns faster than psql or JDBC calls.
Дата
Msg-id 8764.1255036739@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Explain Analyze returns faster than psql or JDBC calls.  (G B <g.b.coder@gmail.com>)
Ответы Re: Explain Analyze returns faster than psql or JDBC calls.  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-performance
G B <g.b.coder@gmail.com> writes:
> How can  explain-analyze return significantly much faster than other means?

If the returned data is large or takes a lot of work to convert to text,
this could happen, since EXPLAIN ANALYZE doesn't bother to format the
tuples for display.  How big are those bytea columns, on average?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin T Pryzby
Дата:
Сообщение: Re: dump time increase by 1h with new kernel
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: dump time increase by 1h with new kernel