Re: SELECT is immediate but the UPDATE takes forever

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: SELECT is immediate but the UPDATE takes forever
Дата
Msg-id AANLkTinjmjXpuF2zjV=SsX6FhZVLNUrvA7vmsrj9mu6-@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT is immediate but the UPDATE takes forever  (Raimon Fernandez <coder@montx.com>)
Ответы Re: SELECT is immediate but the UPDATE takes forever  (Raimon Fernandez <coder@montx.com>)
Список 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 по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: How to obtain the maximum value of a date, between 3 tables...
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Asynchronous query execution