Re: lots of updates on small table

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: lots of updates on small table
Дата
Msg-id 20050715003729.GB23728@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: lots of updates on small table  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-performance
On Thu, Jul 14, 2005 at 08:28:24PM -0400, Alvaro Herrera wrote:
> On Fri, Jul 15, 2005 at 09:42:12AM +1000, Alison Winters wrote:
>

> > INFO:  Pages 1221: Changed 3, reaped 256, Empty 0, New 0; Tup 108137: Vac 4176, Keep/VTL 108133/108133, UnUsed 19,
MinLen84, MaxLen 84; Re-using: Free/Avail. Space 445176/371836; EndEmpty/Avail. Pages 0/256. 
>
> Hmm, so it seems your hourly vacuum is enough.  I think the bloat theory
> can be trashed.  Unless I'm reading this output wrong; I don't remember
> the details of this vacuum output.

Ok, so I was _very_ wrong :-)  Sorry.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: lots of updates on small table
Следующее
От: David Mitchell
Дата:
Сообщение: Re: performance problems ... 100 cpu utilization