help with query speed

[Jason Tesser]

I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20 seconds.
Is their a better way I can write the joins. I would think that
Postgres should be fast than Access. BTW I am writing these as
Pass through queries so it is not a problem with Access. I have
Even ran the query directly against Postgres.

SELECT
tblroster.trans criptlink
FROM
tblroster
FULL OUTER JOIN testclass ON (tblroster.clas slink = testclass.class id)
FULL OUTER JOIN tblqualitypoint ON (tblroster.lett ergrade =
tblqualitypoint .letter)
ORDER BY
tblroster.trans criptlink

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[scott.marlowe]

On Thu, 12 Feb 2004, Jason Tesser wrote:

I have the below query written. I have removed a lot from the select
Statement for simplicity sake. The query takes way too long.
I am moving from an Access backend to a Postgres back with
Access in the front. The below query is taking like 14-20 seconds.
Is their a better way I can write the joins. I would think that
Postgres should be fast than Access. BTW I am writing these as
Pass through queries so it is not a problem with Access. I have
Even ran the query directly against Postgres.

SELECT
tblroster.trans criptlink
FROM
tblroster
FULL OUTER JOIN testclass ON (tblroster.clas slink = testclass.class id)
FULL OUTER JOIN tblqualitypoint ON (tblroster.lett ergrade =
tblqualitypoint .letter)
ORDER BY
tblroster.trans criptlink

Are tblroster.class link and testclass.class id the same type and indexed?

Same for tblroster.lette rgrade and tblqualitypoint .letter

Also is tblroster.trans criptlink indexed? Is the query using indexes?
Check it with

explain analyze <query>

and see what it says, look for big differences between expected and actual
rows, width, and loops.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org