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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
