How to configure a read-only database server?
От | Stefan Keller |
---|---|
Тема | How to configure a read-only database server? |
Дата | |
Msg-id | BANLkTinA9B=80cG8R=132RTxF52K=Mdfuw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: How to configure a read-only database server?
Re: How to configure a read-only database server? Re: How to configure a read-only database server? Re: How to configure a read-only database server? |
Список | 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
В списке pgsql-performance по дате отправления: