Re: VACUUM

Anderson dos Santos Donda wrote:
> Anyone can explain this:
>
> INFO: free space map contains 5848 pages in 5000 relations
> DETAIL: A total of 83728 page slots are in use (including overhead).
> 83728 page slots are required to track all free space.
> Current limits are: 153600 page slots, 5000 relations, using 1228 kB.
> NOTICE: max_fsm_relations(5000) equals the number of relations checked
>
>
> I increase the relations but doesn't work... and if a increase more
> than 7000, postgre doesn't work because the shared memory kernel...
>
> What I do?

you probably have to increase the SHMMAX in the kernel, how you do this
depends on the OS and distribution.

for instance... in a Red Hat style linux distribution,
/etc/sysctl.conf, add a line...

kernel.shmmax = 500000000

(thats about 500MB, the value you use should be appropriate for the
system... I generally allow around 1/2 of physical ram for this, this is
just a limit, and won't have any impact if you don't actually use this much)

on a older Solaris version, in /etc/system

set shmsys:shminfo_shmmax=500000000

in a newer solaris system... execute the command...

# projadd -U postgres -c "PostgreSQL Server" \
-K "project.max-shm-memory=(priv,500MB,deny)" \
postgresql

which sets that limit just for processes running as the postgres user
rather than globally.