Re: Query performance with small data base

On Thu, 17 Oct 2002, pginfo wrote:

> Hi all,
>
> >From couple of days I make some tests for postgresql performance.
> The results are not optimistic for the moment.
> The idea of tests is to view if postgres is good for our new project.
>
> The test platform:
>
> RH 7.3 on Dual P III 1 GHz , 1GB RAM.
>
> The test query:
>
>  explain analyze select
> S.IDS_NUM,S.OP,S.KOL,S.OTN_MED,S.CENA,S.DDS,S.KURS,S.TOT,S.DTO,S.PTO,S.DTON,MED.MNAME
> AS MEDNAME,N.MNAME AS NOMENNAME,N.NUM AS NNUM,S.PART,S.IZV  from   A_DOC
> D  left outer join A_KLIENTI KL ON(D.IDS_KO=KL.IDS) , A_SKLAD S left
> outer join  A_NOMEN N ON(S.IDS_NUM=N.IDS) left outer join  A_MED MED ON
> (N.OSN_MED=MED.IDS )     WHERE S.FID=0 AND S.IDS_DOC=D.IDS  AND
> D.DATE_OP >= 8353 AND D.DATE_OP <= 9983  ORDER BY  S.IDS_NUM,S.PART,S.OP
> ;
> NOTICE:  QUERY PLAN:

Hmm, what are the table schemas and how many rows are in the full tables?