Re: Notification when freespaces empty
От | Simon Riggs |
---|---|
Тема | Re: Notification when freespaces empty |
Дата | |
Msg-id | 1116588062.3844.305.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Notification when freespaces empty (ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>) |
Ответы |
Re: Notification when freespaces empty
|
Список | pgsql-hackers |
On Fri, 2005-05-20 at 14:41 +0900, ITAGAKI Takahiro wrote: > LOG: FreeSpace for "public.accounts" becomes empty. (stored=1, avg=159, min=128) Looks useful to me, until we patch up FSMs more fully in the future. Might need rewording. Stored -> stored pages, Avg -> Avg Row Length. Probably should be a DEBUG1 log line also. It would be even more useful if this was signalled (perhaps to stats) in such a way that autovacuum could act upon this knowledge. > Furthermore, this patch detaches empty fsmpages then. > Freespaces keep being scanned after they empties, > but it seems to be bootless effort. Does that do anything useful though? I thought we don't reallocate until VACUUM time, whereupon we identify any empty slots and reuse them. Who cares whether we deallocate earlier? Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления: