Re: Optimizing a read-only database

> François Battail  hat am 18. Mai 2015 um 16:07
> geschrieben:
> 
> 
> Dear List,
> 
> I would like to know if somebody is aware of tricks for optimizing 
> PostgreSQL settings for a read-only database.

you can set fillfactor to 100


alter table ... set (fillfactor = 100), see
http://www.postgresql.org/docs/9.4/static/sql-altertable.html and
http://www.postgresql.org/docs/9.4/static/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS.

And you can disable VACUUM.