| From: | John A Meinel <john(at)arbash-meinel(dot)com> |
|---|---|
| To: | Hasnul Fadhly bin Hasan <hasnulfadhly(dot)h(at)mimos(dot)my> |
| Cc: | Bryan <bvest(at)rhondasworld(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Config Check |
| Date: | 2004-12-07 02:54:42 |
| Message-ID: | 41B51B72.3050000@arbash-meinel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hasnul Fadhly bin Hasan wrote:
> Hi Bryan,
>
> Just wondering, i ran vacuumdb but didn't get the information that you
> get about the free space even when i set the verbose option. How did
> you get that?
>
> Thanks,
>
> Hasnul
I believe it is
VACUUM FULL ANALYZE VERBOSE;
At the very end you will get a listing like
INFO: free space map: 167 relations, 423 pages stored; 2912 total pages
needed
DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 186 kB
shared memory.
(Yes, mine is done on a very static table.)
John
=:->
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2004-12-07 04:16:01 | Re: scaling beyond 4 processors |
| Previous Message | Jeff | 2004-12-07 02:52:26 | Re: scaling beyond 4 processors |