"Chris Hoover" <[EMAIL PROTECTED]> writes:
> Here is the postgresql.conf from the server with the 11GB db:

> max_fsm_pages = 10000         # min 1000, fsm is free space map, ~6 bytes

It's unlikely that that's enough for an 11Gb database, especially if
you're only vacuuming a few times a week.  You should make your next run
be a "vacuum verbose" and look at the output to get an idea of what sort
of table bloat you're seeing, but I'll bet it's bad ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to