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? If not, what configuration of WAL/Checkpoint settings
would result in minimal WAL activity?
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?)
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.
-
DAP
----------------------------------------------------------------------------------
David
Parker Tazz Networks (401)
709-5130
