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
