pgsql: Default to log_lock_waits=on

Default to log_lock_waits=on

If someone is stuck behind a lock for more than a second, that is
almost always a problem that is worth a log entry.

Author: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Reviewed-By: Michael Banck <mbanck(at)gmx(dot)net>
Reviewed-By: Robert Haas <robertmhaas(at)gmail(dot)com>
Reviewed-By: Christoph Berg <myon(at)debian(dot)org>
Reviewed-By: Stephen Frost <sfrost(at)snowman(dot)net>
Discussion: https://postgr.es/m/b8b8502915e50f44deb111bc0b43a99e2733e117.camel%40cybertec.at

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2aac62be8cbb870ccf8c5b3fbb8a4e4aa8a14a73

Modified Files
--------------
doc/src/sgml/config.sgml | 2 +-
src/backend/storage/lmgr/proc.c | 2 +-
src/backend/utils/misc/guc_parameters.dat | 2 +-
src/backend/utils/misc/postgresql.conf.sample | 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)