| From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
|---|---|
| To: | robert(at)webtent(dot)com |
| Cc: | Robert Fitzpatrick <lists(at)webtent(dot)net>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: autovacuum |
| Date: | 2007-09-20 20:27:47 |
| Message-ID: | 20070920162747.f5b29c4a.wmoran@potentialtech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In response to Robert Fitzpatrick <lists(at)webtent(dot)net>:
> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
> > That doesn't mean you're vacuuming often enough, however. Switch your
> > nightly vacuum to vacuum verbose and capture the output to see how much
> > work it has to do. Are your fsm settings high enough?
<snip>
> INFO: free space map contains 30078 pages in 41 relations
> DETAIL: A total of 30304 page slots are in use (including overhead).
> 30304 page slots are required to track all free space.
> Current limits are: 204800 page slots, 1000 relations, using 1265 kB.
This was what I was most concerned about. If your FSM settings are too
low, vacuum won't be able to fully do its job. But it looks like you're
OK here.
--
Bill Moran
http://www.potentialtech.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2007-09-20 20:38:38 | Re: autovacuum |
| Previous Message | Ilan Volow | 2007-09-20 20:21:11 | Re: Manually clearing "database "foo" is being accessed by other users" |