From: philippe <pg@rimbault.org>
To: pgsql-performance@postgresql.org
Subject: Re: How to configure a read-only database server?
Date: Tue, 19 Apr 2011 09:45:56 +0200
Message-ID: <4DAD3DB4.2040501@rimbault.org> (raw)
In-Reply-To: <BANLkTinA9B=80cG8R=132RTxF52K=Mdfuw@mail.gmail.com>
References: <BANLkTinA9B=80cG8R=132RTxF52K=Mdfuw@mail.gmail.com>
hi,
Perhaps in postgresql.conf :
default_transaction_read_only
regards
philippe
Le 19/04/2011 00:08, Stefan Keller a écrit :
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@rimbault.org
Subject: Re: How to configure a read-only database server?
In-Reply-To: <4DAD3DB4.2040501@rimbault.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox