On Apr 18, 2011, at 6:08 PM, Stefan Keller <sfkeller(at)gmail(dot)com> wrote:
> 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
> This is what I found so far:
> * Disabling autovacuum daemon.
> * Setting postgresql.conf parameters:
All of those speed up writes. I don't know that they will make any difference at all on a read-only workload.
> * What about wal_level and archive_mode?
Same with these.
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2011-04-23 16:11:38|
|Subject: Re: Shouldn't we have a way to avoid "risky" plans?|
|Previous:||From: Henry||Date: 2011-04-23 15:48:35|
|Subject: Re: not using partial index|