Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT is immediate but the UPDATE takes forever - Mailing list pgsql-general

From Vick Khera
Subject Re: SELECT is immediate but the UPDATE takes forever
Date
Msg-id AANLkTinFWjd5tU3urAEsvnEptp32eZxGO3eCO8goW51q@mail.gmail.com
Whole thread Raw
In response to Re: SELECT is immediate but the UPDATE takes forever  (Raimon Fernandez <coder@montx.com>)
Responses Re: SELECT is immediate but the UPDATE takes forever  (Raimon Fernandez <coder@montx.com>)
List pgsql-general
Tree view 
On Wed, Dec 8, 2010 at 10:58 PM, Raimon Fernandez <coder@montx.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.

pgsql-general by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Tuning Postgres for single user manipulating large amounts of data
Next
From: Paul Taylor
Date:
Subject: Tuning Postgres for single user manipulating large amounts of data