Hi all,
inspired by the last posting "Weird disk write load caused by
PostgreSQL?" i increased the work_mem from 1 to 7MB and did some
loadtest with vacuum every 10 minutes. The system load (harddisk) went
down and everything was very stable at 80% idle for nearly 24 hours!
I am currently performing some pgbench runs to evaluate the hardware
and configuration for the system but i think the biggest problems are
solved so far.
thx everybody,
Peter
2006/10/2, Tom Lane <tgl@sss.pgh.pa.us>:
> Ray Stell <stellr@cns.vt.edu> writes:
> > How would one determine the lock situation definitively? Is there
> > an internal mechanism that can be queried?
>
> pg_locks view.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>