Re: Optimizing a read-only database

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: François Battail <francois(dot)battail(at)sipibox(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing a read-only database
Date: 2015-05-18 14:20:32
Message-ID: 599306455.216761.1431958832602.JavaMail.open-xchange@oxweb02.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> François Battail <francois(dot)battail(at)sipibox(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Koray Eyidoğan 2015-05-18 14:34:21 Re: pg_xlog Concern
Previous Message François Battail 2015-05-18 14:07:34 Optimizing a read-only database