Re: WAL on a RAM disk

David Parker wrote:

> As part of our application we are running a postgres server on a RAM
> disk. All of the data stored in this database is obviously disposable,
> and we need to optimize access as much as possible. This is on Solaris
> 9/intel, postgres 7.4.5. Some things I'm wondering about:
>
> 1) is it possible to turn off WAL entirely?

No.

> If not, what configuration of WAL/Checkpoint settings would result in
> minimal WAL activity?

You could turn off fsync.

>
> 2) Given that the whole database is in memory, does it make sense to
> set random_page_cost to a high value...or, um... a low value? (Does it
> show that I don't understand this parameter?)

Low.

>
> 3) Any other settings I should be looking at?
>
> Thanks. I don't know if anybody else has done this, but I'd be
> interested to hear about it, if so.

You could get a small solid state disk and put your wal on that.

Sincerely,

Joshua D. Drake

> - DAP
> ----------------------------------------------------------------------------------
> David Parker Tazz Networks (401) 709-5130
>
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL