Dear,
From time to time we receive some DEBUG information in the
/var/log/messages
logger: DEBUG: SendSharedInvalidMessage: SI buffer
overflow
I assume this is a parameter witch is too low, can anybody tell
me what parameter this is
Our settings:
THE OS
Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i686
Postgresql version
psql (PostgreSQL) 7.2.3
contains support for: readline, history
Portions Copyright (c) 1996-2001, PostgreSQL Global Development
Group
Portions Copyright (c) 1996, Regents of the University of
California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
The config file
#max_connections = 32
# VKP max_connections = 64
max_connections = 64
#port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777
#virtual_host = ''
#krb_server_keyfile = ''
#
# Shared Memory Size
#
#shared_buffers = 64 #
2*max_connections, min 16
# VKP shared_buffer = 8192
shared_buffers = 8192
#max_fsm_relations = 100 # min 10, fsm is free space
map
#max_fsm_pages = 10000 # min 1000, fsm is
free space map
#max_locks_per_transaction = 64 # min 10
#wal_buffers =
8 # min
4
#
# Non-shared Memory Sizes
#
#sort_mem =
512
# min 32
# VKP sort_mem = 16384
sort_mem = 16384
#vacuum_mem = 8192
# min 1024
#
# Write-ahead log (WAL)
#
#wal_files = 0 # range 0-64
#wal_sync_method = fsync # the default varies across
platforms:
#
# fsync, fdatasync, open_sync, or open_datasync
#wal_debug =
0
# range 0-16
#commit_delay = 0 #
range 0-100000
#commit_siblings = 5 # range
1-1000
#checkpoint_segments = 3 # in logfile segments (16MB each),
min 1
#checkpoint_timeout = 300 # in seconds, range 30-3600
#fsync = true
# VKP fsync = false
fsync = false
Thanks in advance
Patrick Meylemans
WTCM-CRIF
Celestijnenlaan 300C
3001 Heverlee
Mobile : +32(0)498 91 93 10
- Re: [ADMIN] SI buffer overflow Patrick Meylemans
- Re: [ADMIN] SI buffer overflow Tom Lane
