| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Interpreting vacuum verbosity |
| Date: | 2004-05-08 00:37:26 |
| Message-ID: | 19791.1083976646@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Boes <jboes(at)nexcerpt(dot)com> writes:
> Tom Lane wrote:
>> INFO: free space map: 280 relations, 520 pages stored; 4720 total pages needed
>> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory.
> And I would assume that if I have three databases defined on my server,
> I should run this for all three and sum the results?
No, the quoted results are cluster-wide.
It is a good idea to vacuum all three databases and then look at the
final results, just to make sure you have reasonably up-to-date info
about every table. But you don't need to sum anything.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis Braekhus | 2004-05-08 15:29:38 | Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT |
| Previous Message | Dennis Gearon | 2004-05-08 00:15:19 | Re: graphical ERD tool |