Re: [GENERAL] execution plan : Oracle vs PostgreSQL

2006-04-11 Thread Simon Riggs
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

Re: [GENERAL] execution plan : Oracle vs PostgreSQL

2006-01-31 Thread Tom Lane
"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

Re: [GENERAL] execution plan : Oracle vs PostgreSQL

2006-01-31 Thread FERREIRA, William (VALTECH)
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