From: | "vinita bansal" <sagivini(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | update queries taking lot of time |
Date: | 2005-02-24 18:21:01 |
Message-ID: | BAY20-F3779CBCDB4290B46B0472BCB640@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am running update query of the form "update tablename set x = y where
exists (select .....)"
These queries are taking lots of time. I dropped all indices on the table
which provided some improvement but not remarkable performance. I am looking
for ways to improve it. Can someone suggest what all can be done to improve
it. These queries are being executed from within a pl/pgsql function.
Regards,
Vinita Bansal
_________________________________________________________________
Try the all-new MSN Search! Find exactly what you want.
http://search.msn.co.in Get more value for your time.
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2005-02-24 18:40:23 | Re: update queries taking lot of time |
Previous Message | Terry Lee Tucker | 2005-02-24 17:49:01 | Re: Questions regarding notify processing. |