Re: SELECT is immediate but the UPDATE takes forever

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT is immediate but the UPDATE takes forever
Date: 2010-12-09 13:32:51
Message-ID: AANLkTinFWjd5tU3urAEsvnEptp32eZxGO3eCO8goW51q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

On Wed, Dec 8, 2010 at 10:58 PM, Raimon Fernandez <coder(at)montx(dot)com> wrote:
> well, after a VACUUM things are going faster ... I'm still trying to analyze the function as it seems there are other bottlechecnk, but at least the first update now is faster as before ...
>

If that's the case then your 'no' answer to "is the table bloated" was
probably incorrect, and your answer to "is your I/O slow to grow a
file" is also probably incorrect.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Richardson 2010-12-09 14:11:39 How can I create a PgAgent job creation script?
Previous Message Paul Taylor 2010-12-09 12:25:56 Tuning Postgres for single user manipulating large amounts of data

Browse pgsql-interfaces by date

  From Date Subject
Next Message Raimon Fernandez 2010-12-09 16:08:41 Re: SELECT is immediate but the UPDATE takes forever
Previous Message Raimon Fernandez 2010-12-09 03:58:55 Re: SELECT is immediate but the UPDATE takes forever