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

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Explain Analyze returns faster than psql or JDBC calls.
Дата
Msg-id 491f66a50910090457j62f62af5o4c74fc707cd8785a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explain Analyze returns faster than psql or JDBC calls.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
You should also keep in mind that JDBC uses prepared statements, so you have to explain analyze accordingly.

Dave

On Thu, Oct 8, 2009 at 5:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Shiva Raman
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!
Следующее
От: Xia Qingran
Дата:
Сообщение: Re: Bad performance of SELECT ... where id IN (...)