Re: LISTEN / NOTIFY performance in 8.3

At 2:57 PM -0500 2/25/08, Tom Lane wrote:
>It's weird that the behavior is robust for you but I can't make it
>happen at all. Would you show the output of pg_config, as well as
>all your nondefault postgresql.conf settings?

pg_config:
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = 'CFLAGS=-O2 -pipe' '--with-openssl'
'--enable-thread-safety' '--with-includes=/usr/kerberos/include'
'--with-perl'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/kerberos/include
CFLAGS = -O2 -pipe -Wall -Wmissing-prototypes -Wpointer-arith
-Winline -Wdeclaration-after-statement -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-rpath,'/usr/local/pgsql/lib'
LDFLAGS_SL =
LIBS = -lpgport -lssl -lcrypto -lz -lreadline -ltermcap -lcrypt -ldl -lm
VERSION = PostgreSQL 8.3.0

Non-default postgresql.conf settings:
max_connections = 80
ssl = on
shared_buffers = 1GB
work_mem = 100MB
maintenance_work_mem = 100MB
max_fsm_pages = 204800
vacuum_cost_delay = 100
wal_buffers = 124kB
wal_writer_delay = 200ms
commit_delay = 100
checkpoint_segments = 6
effective_cache_size = 6GB