| 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: | 2005-05-20 11:21:02 |
| Message-ID: | 1116588062.3844.305.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-05-20 11:55:05 | Re: 8.02 rpm error |
| Previous Message | Simon Riggs | 2005-05-20 11:11:43 | Re: [HACKERS] Inherited constraints and search paths (was Re: |