Обсуждение: update queries taking lot of time

Поиск
Список
Период
Сортировка

update queries taking lot of time

От
"vinita bansal"
Дата:
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.


Re: update queries taking lot of time

От
"Dann Corbit"
Дата:
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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of vinita bansal
Sent: Thursday, February 24, 2005 10:21 AM
To: pgsql-general@postgresql.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