On Sun, Aug 21, 2011 at 1:20 PM, Greg Smith wrote:
> deadlock_timeout = 3s
>
> You probably don't want to increase this. When you reach the point where
> you want to find slow lock issues by turning on log_lock_waits, you're just
> going to put it right back to the default again--or lower it.
A
On 08/18/2011 05:55 PM, Midge Brown wrote:
DB1 is 10GB and consists of multiple tables that I've spread out so
that the 3 most used have their data and indexes on 6 separate RAID1
drives, the 3 next busiest have data & index on 3 drives, and the
remaining tables and indexes are on the RAID10 dr
On Sat, Aug 20, 2011 at 8:33 PM, Midge Brown wrote:
> Robert,
>
> I was largely looking for input on whether I may have inadvertently shot
> myself in the foot with some of the choices I made when setting up
> postgresql 9.0, which is on different hardware than was the 7.4 setup.
OK, I though the
