Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Notification when freespaces empty
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Notification when freespaces empty
- Date: Fri, 20 May 2005 12:21:02 +0100
- Message-id: <1116588062.3844.305.camel@localhost.localdomain> <text/plain>
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
- Follow-Ups:
- Re: Notification when freespaces empty
- From: ITAGAKI Takahiro
- Re: Notification when freespaces empty
- References:
- Notification when freespaces empty
- From: ITAGAKI Takahiro
- Notification when freespaces empty
- Prev by Date: Re: Inherited constraints and search paths (was Re:
- Next by Date: Re: 8.02 rpm error
- Previous by thread: Notification when freespaces empty
- Next by thread: Re: Notification when freespaces empty
- Indexes: