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@think.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