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

2009-10-09 Thread Dave Cramer
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 wrote: > G B writes: > > How can explain-analyze return significantly much faster than other > means? > > If the returned data is large or

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

2009-10-08 Thread Tom Lane
G B 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