Re: updating a row in a table with only one row

Поиск
Список
Период
Сортировка
От Hélder M. Vieira
Тема Re: updating a row in a table with only one row
Дата
Msg-id FA02B0B91C8C4F6D8CA0455C580DC80C@Hmv03
обсуждение исходный текст
Ответ на updating a row in a table with only one row  (Michal Vitecek <fuf@mageo.cz>)
Список pgsql-performance
> There are ~100 tables in the database and one of them (tableOne) always
> contains only a single row. There's one index on it. However performing
> update on the single row (which occurs every 60 secs) takes a
> considerably long time -- around 200ms. The system is not loaded in any
> way.


How often is the the table VACUUMed ?
At the mentioned update rate, the table has a daily growth of 1440 dead row
versions.

Helder M. Vieira




В списке pgsql-performance по дате отправления:

Предыдущее
От: Scara Maccai
Дата:
Сообщение: Re: Best suiting OS
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Best suiting OS