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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



G B <g.b.coder@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux