Re: SELECT is immediate but the UPDATE takes forever

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: SELECT is immediate but the UPDATE takes forever
Дата
Msg-id AANLkTinFWjd5tU3urAEsvnEptp32eZxGO3eCO8goW51q@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
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Reid Thompson
Дата:
Сообщение: Re: Tuning Postgres for single user manipulating large amounts of data
Следующее
От: Paul Taylor
Дата:
Сообщение: Tuning Postgres for single user manipulating large amounts of data