Skip site navigation (1) Skip section navigation (2)

Re: update queries taking lot of time

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "vinita bansal" <sagivini(at)hotmail(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: update queries taking lot of time
Date: 2005-02-24 18:40:23
Message-ID: D425483C2C5C9F49B5B7A41F8944154705596F@postal.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-general
Give the schema of your table.

Give the exact query/queries you are running.

Give the cardinality of the table.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of vinita bansal
Sent: Thursday, February 24, 2005 10:21 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] update queries taking lot of time

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.


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

               http://archives.postgresql.org

pgsql-general by date

Next:From: Craig BrydenDate: 2005-02-24 18:41:38
Subject: Re: ADO and timestamp/date errors
Previous:From: vinita bansalDate: 2005-02-24 18:21:01
Subject: update queries taking lot of time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group