| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Confused about FSM numbers |
| Date: | 2005-11-30 15:16:19 |
| Message-ID: | 16683.1133363779@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> I have never figured out what the FSM numbers printed by VACUUM VERBOSE really
> meant. I have for example,
> INFO: free space map: 101 relations, 150 pages stored; 1664 total pages
> needed
> What exactly does that last number mean? I have 20000 pages configured for
> the FSM, so if it needs 1664, why does it only take 150?
The FSM allocations are quantized (16 pages per chunk IIRC). So to
store one page for each of 101 relations you'd need 1616 page slots.
It looks like you have three more chunks than the minimum, so some
of those relations have more than 16 pages with free space, but not
very many ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomeh, Husam | 2005-12-01 01:33:19 | Re: upgrade database to 8.1 - 2GB file limit (pg_dump) |
| Previous Message | Peter Eisentraut | 2005-11-30 14:56:48 | Confused about FSM numbers |