Postgres Pro
Downloads
Home   >   mailing lists

Re: Update is very slow on a bigger table - Mailing list pgsql-sql

From Tom Lane
Subject Re: Update is very slow on a bigger table
Date
Msg-id 21949.1082069503@sss.pgh.pa.us
Whole thread Raw
In response to Update is very slow on a bigger table  (Dimitar Georgievski <dgeorgievski@horizonk.com>)
Responses Re: Update is very slow on a bigger table  (Dimitar Georgievski <dgeorgievski@horizonk.com>)
List pgsql-sql
Tree view 
Dimitar Georgievski <dgeorgievski@horizonk.com> writes:
> the process under which the update is running reports among the usual
> process data "UPDATE waiting".

I don't think the UPDATE is doing anything at all --- that ps output
implies that it's waiting for some other backend to release an exclusive
lock on the table, or an update lock on one of the rows to be updated.

The pg_locks view might help you determine who's the culprit.
        regards, tom lane

pgsql-sql by date:

Previous
From: Dimitar Georgievski
Date:
Subject: Update is very slow on a bigger table
Next
From: Dimitar Georgievski
Date:
Subject: Re: Update is very slow on a bigger table