> François Battail <francois.batt...@sipibox.fr> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
