On Sun, Aug 21, 2011 at 1:20 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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. All of these random changes brings up the REAL subject, that changes should be made by measuring performance before and after each change set and justifying each change. Just randomly throwing what seem like good changes at the database is a surefire recipe for disaster. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
