Perhaps in postgresql.conf :
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
> This is what I found so far:
> * Disabling autovacuum daemon.
> * Setting postgresql.conf parameters:
> * 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
In response to
pgsql-performance by date
|Next:||From: Robert Klemme||Date: 2011-04-19 08:24:18|
|Subject: Re: big distinct clause vs. group by|
|Previous:||From: Stefan Keller||Date: 2011-04-18 22:08:38|
|Subject: How to configure a read-only database server?|