On Thu, 2002-01-24 at 20:47, Peter T. Brown wrote:
> That helps a great deal! I am learning about the 'run-fast' option in
> postgres: Increasing the shared_buffers is critical. Here is a copy of my
> postgresql.conf file. I'll make the increases you suggested, but is there
> anything else you can recomend?
>
> Thanks again,
>
> Peter
>
>
>
> postgresql.conf:
>
....
I belive you should set
fsync=false
in case you mainly select and do inserts rather rare. The ideea is to
keep/operate the db in/from memory, while fsync=true will get your
system to sync every write to hdd. Or at least that's what i understood
from the docs.
--
Radu-Adrian Popescu
CSA, DBA, Programmer