Optimizing queries - Mailing list pgsql-general

From Work
Subject Optimizing queries
Date
Msg-id aeqjev$2gts$1@news.hub.org
Whole thread Raw
Responses Re: Optimizing queries  (Scott Marlowe <scott.marlowe@ihs.com>)
List pgsql-general
Hi ,

I am a newbie to the world of Postgres, I am currently optimizing
PHP/Postgres applications. My problem is that I have a query that throws
certain rowsets and depending on these values I loop other tables to get the
desired columns. I am using a heavy for-loop for this purpose, within the
for-loop I have further sub-queries, so that for every loop iteration I
execute these sub-queries, I dont see a way to reorganize this structure.
Can somebody suggest a better way.

Thanks
Regards
Sid



pgsql-general by date:

Previous
From: "David Siebert"
Date:
Subject: Re: PostgreSQL.org : A new website design offer
Next
From: "Henrik Steffen"
Date:
Subject: Re: Serious Crash last Friday