Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing a read-only database - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Optimizing a read-only database
Date
Msg-id 599306455.216761.1431958832602.JavaMail.open-xchange@oxweb02.ims-firmen.de
Whole thread Raw
In response to Optimizing a read-only database  (François Battail <francois.battail@sipibox.fr>)
Responses Re: Optimizing a read-only database
List pgsql-general
Tree view 

> François Battail <francois.battail@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.

pgsql-general by date:

Previous
From: François Battail
Date:
Subject: Optimizing a read-only database
Next
From: Koray Eyidoğan
Date:
Subject: Re: pg_xlog Concern