Keith,

> Thanks to all on the NOVICE list that gave me help I now have a query
> running that returns the results I am after. :-) *Now of course I want it
> to run faster. *Currently it clocks in at ~160ms. *I have checked over the
> indexes and I belive that the tables are indexed properly. *The largest
> table, tbl_item, only has 2000 rows. *Is it possible to reduce the time of
> this query further? *

Probably not, no. For a 7-way join including 2 LEFT JOINs on the
unrestricted contents of all tables, 160ms is pretty darned good. If these
tables were large, you'd be looking at a much longer estimation time. The
only real way to speed it up would be to find a way to eliminate the left
joins. Also, PostgreSQL 8.0 might optimize this query a little better.

The only thing I can see to tweak is that the estimate on the number of rows
in tbl_item is wrong; probably you need to ANALYZE tbl_item. But I doubt
that will make a difference in execution time.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org