From: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
---|---|
To: | postgres <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: Performance issue 6.5 versus 7.0 |
Date: | 2000-05-26 20:46:00 |
Message-ID: | 392EE288.F11EBC8D@thinx.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bryan White wrote:
>
> > Is there a way to force 7.0 using the defined indexes? Thanks
> > for your help.
>
> Try set enable_seqscan=off before issuing your query.
A little bit better (3 sec instead of 5 seconds). But fare away
from the performance of 6.5.3. The explain now looks like this:
EXPLAIN
SELECT MailingListe_Id, MailingStatus, AbschlussDatum, Anschrift.Anzeige,
Anschrift.Postfach, Anschrift.Strasse, Anschrift.Plz, Anschrift.Ort,
Anschrift.TelDirekt, Person.Person_Id, Person.Name, Person.Vorname,
Person.Anzeige
FROM Anschrift, Person, MailingListe
WHERE Person.Person_Id = MailingListe.Person_Id
AND Anschrift.Anschrift_Id = MailingListe.Anschrift_Id
AND MailingListe_Id = 2104;
NOTICE: QUERY PLAN:
Merge Join (cost=3717.38..7842.55 rows=1988449 width=136)
-> Sort (cost=3717.38..3717.38 rows=8268 width=96)
-> Merge Join (cost=44.73..2941.79 rows=8268 width=96)
-> Index Scan using anschrift_id_ix on anschrift (cost=0.00..2725.55 rows=13661 width=76)
-> Sort (cost=44.73..44.73 rows=61 width=20)
-> Index Scan using mailingliste_id_ix on mailingliste (cost=0.00..42.94 rows=61 width=20)
-> Index Scan using person_id_ix on person (cost=0.00..3721.19 rows=24051 width=40)
An other advice?
Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti E-Mail: Herbert(dot)Liechti(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2000-05-26 20:55:02 | Re: Performance issue 6.5 versus 7.0 |
Previous Message | Alfred Perlstein | 2000-05-26 20:21:57 | Re: Update Performance from 6.5.0 to 6.5.3 to 7.0 |