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