On Tue, 2006-01-24 at 11:33 +0100, FERREIRA, William (VALTECH) wrote:
> the times are always the same, except with the centrino for which it takes 1
> min.
Oracle or PostgreSQL? i.e. is the Centrino faster or slower?
> -Postgresql plan :
Please post the EXPLAIN ANALYZE.
Thanks,
--
Simon Ri
"FERREIRA, William (VALTECH)" <[EMAIL PROTECTED]> writes:
> here is the EXPLAIN ANALYSE of my query :
That's not an EXPLAIN ANALYZE ... that's an EXPLAIN VERBOSE, which is
hardly ever of any use for performance issues.
regards, tom lane
---(end of
here is the EXPLAIN ANALYSE of my query :
{SORT
:startup_cost 9.65
:total_cost 9.66
:plan_rows 1
:plan_width 28
:targetlist (
{TARGETENTRY
:expr
{VAR
:varno 1
:varattno 1
:vartype 23
:vartypmod -1
:varlevelsup 0