Re: Same conditions, different planning?

On Wednesday 22 October 2003 16:25, Pedro Alves wrote:

> Machine 1:
>
> explain select count(*) from requisicaoanalise where isactive = 1 AND
> (ra_servico = 4) AND (ra_datacolh <= '2003-10-22'::date);
> QUERY PLAN
> ---------------------------------------------------------------------------
>-------------------- Aggregate (cost=948.45..948.45 rows=1 width=0)
> -> Index Scan using ra_isactive on requisicaoanalise
> (cost=0.00..947.07 rows=550 width=0)
> Index Cond: (isactive = 1)
> Filter: ((ra_servico = 4) AND (ra_datacolh <= '2003-10-22'::date))
> (4 rows)

Could you please run explain analyze rather than just explain for all the
things you posted earlier?

And are there any tuning parameters different on these two machines? RAM size
of HDD setup etc?

Are these two machine absolutely same from hardware and postgresql tuning
point of view?

Shridhar