From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Enix Empreendimentos e Construções "Ltda(dot)" <contato(at)enix(dot)com(dot)br> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgresql performance |
Date: | 2003-03-13 22:26:20 |
Message-ID: | 1047594379.1709.98.camel@fuji.krosing.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Enix Empreendimentos e Construções Ltda. kirjutas K, 12.03.2003 kell
22:47:
> Hi everybody.
>
> I am a newbie to Postgresql, trying to migrate an application from MSAccess.
>
> I am quite dissapointed with the problems I am facing with some queries
> containing multiple joins.
Postgres currently does *not* optimize join order for explicit joins
(this is currently left as a cludge for users to hand-optimize query
plans).
To get the benefits form optimiser you have to rewrite
FROM TA JOIN TB ON TA.CB=TB.CB
to
FROM A,B
WHERE TA.CB=TB.CB
> I confess it has been hard for someone that is
> not a DBA to figure out which are the problems. Just to ilustrate, I have
> some queries that provide a reasonable query plan (at least from my point of
> view), but that return no result: keep running on and on.
Could you try to explain it in other words (or give an example). I am
not native english speaker and I can read your text in at least 5
different ways ;(
> Is the performance of the mentioned Postgresql version much slower than the
> 7.3.1?
It can be slower. It may also be a little faster in some very specific
cases ;)
--------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-03-14 17:10:06 | Re: speeding up COUNT and DISTINCT queries |
Previous Message | Max Baker | 2003-03-13 20:22:54 | Re: speeding up COUNT and DISTINCT queries |