From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query performance with small data base |
Date: | 2002-10-17 18:09:30 |
Message-ID: | 20021017110258.J10848-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-10-17 18:13:08 | Re: [SQL] isAutoIncrement and Postgres |
Previous Message | Alvaro Herrera | 2002-10-17 17:30:40 | Re: Help normalizing table(s) |