> Well whatdyaknow?? Being a Postgres newbie I hadn't even played with indexes
> yet. They're awesome!!
> Using Richard's suggestion of the Sub-Select in the COLUMN list, combined
> with adding some indexes, I can now return this in under 5 seconds!
Also, another way to improve preformance will be to analyze the affected
tables. Analyze will
ensure that the query planner has accurate statics by which it will use in
picking fastest
possible query.
If you ever plan on updating or deleting records. You will also need to vacuum
the table. And an
additional measure of maintance would be to re-index the database.
All of this is listing in the postgresql manual. If you really want to ensure
the best possible
speeds, it will be an important step to take.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
