"Chris Hoover" <revoohc(at)sermonaudio(dot)com> 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