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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org