How to configure a read-only database server?

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to configure a read-only database server?
Date: 2011-04-18 22:08:38
Message-ID: BANLkTinA9B=80cG8R=132RTxF52K=Mdfuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I browsed the faq and looked at PostgreSQL performance books but I
could not find the obvious:
How to configure a read-only database server?

I have a single-disk virtual Linux system and a read-only dataset
which is exposed to internet and completely replaced from time to
time.

This is what I found so far:

* Disabling autovacuum daemon.
* Setting postgresql.conf parameters:
fsync=off
synchronous_commit=off
full_page_writes=off

* For the session:
SET transaction_read_only TO FALSE;
SET TRANSACTION READ ONLY;

* What about wal_level and archive_mode?

=> Any comments on speeding up/optimizing such database server?

Yours, Stefan

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message philippe 2011-04-19 07:45:56 Re: How to configure a read-only database server?
Previous Message Pierre C 2011-04-18 21:21:56 Re: Background fsck