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-08 17:18:05
Message-ID: AANLkTinjmjXpuF2zjV=SsX6FhZVLNUrvA7vmsrj9mu6-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

2010/12/7 Raimon Fernandez <coder(at)montx(dot)com>:
> I'm using now another database with same structure and data and the delay doesn't exist there, there must be something wrong in my current development database.
>

does autovacuum run on it? is the table massively bloated? is your
disk system really, really slow to allocate new space?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2010-12-08 17:52:04 Re: How to obtain the maximum value of a date, between 3 tables...
Previous Message Adrian Klaver 2010-12-08 17:12:05 Re: Maximum size for char or varchar with limit

Browse pgsql-interfaces by date

  From Date Subject
Next Message Raimon Fernandez 2010-12-09 03:40:13 use a variable name for an insert in a trigger for an audit
Previous Message Alban Hertroys 2010-12-07 18:20:08 Re: SELECT is immediate but the UPDATE takes forever