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 AANLkTinjmjXpuF2zjV=SsX6FhZVLNUrvA7vmsrj9mu6-@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
2010/12/7 Raimon Fernandez <coder@montx.com>:
> I'm using now another database with same structure and data and the delay doesn't exist there, there must be
somethingwrong 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?

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: How to obtain the maximum value of a date, between 3 tables...
Next
From: Merlin Moncure
Date:
Subject: Re: Asynchronous query execution