"Thilo Hille" <thilo(at)resourcery(dot)de> writes:
> Would it make sense to lower the shmall & shmmax kernelvalues according to
> the buffers memory too?
Don't think it matters.
>> Here you are hurting: less than one tuple per page. This table
>> desperately needs a VACUUM FULL.
> How about a table dump and restore. Would it solve the problem without a
> full vac?
Yeah, but if your objective is to keep the table accessible
continuously, that's not going to help ...
regards, tom lane