Re: Same conditions, different planning?

As a final attempt I tryed a pg_dumpall; initdb; psql -f <file> . It
seems to work as expected.... (!)

On Wed, Oct 22, 2003 at 05:03:32PM +0530, Shridhar Daithankar wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
Pedro Miguel G. Alves pmalves(at)think(dot)pt
THINK - Tecnologias de Informação www.think.pt
Tel: +351 21 413 46 00 Av. José Gomes Ferreira
Fax: +351 21 413 46 09 nº 13 1495-139 ALGÉS