Re: Major Performance decrease after some hours

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(at)sss(dot)pgh(dot)pa(dot)us>:
> Ray Stell <stellr(at)cns(dot)vt(dot)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
>