Re: dbsize

Hi,

> Hm. I cannot see anything wrong with the source code for database_size.
> I notice though that it depends on vsnprintf, which is known to be buggy
> in some releases of Solaris. Did you use the patch suggested in the
> last entry of doc/FAQ_Solaris?
>

I can't find any infos about patches in the FAQ

bash-2.03# grep -i patch FAQ_Solaris

> > This started to happen when I increased memory sizes in the
> > postgresql.conf.
>
> From what, to what?
>
> regards, tom lane

ok. first of all. here are the entries from /etc/system

set shmsys:shminfo_shmmax=1073741824
set semsys:seminfo_semmap=64
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=100
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=100

and the entries from postgresql.conf. values where changed from default.

shared_buffers = 1024 # 2*max_connections, min 16, typically 8KB
each
max_fsm_relations = 100 # min 10, fsm is free space map, ~40 bytes
max_fsm_pages = 10000 # min 1000, fsm is free space map, ~6 bytes
max_locks_per_transaction = 128 # min 10
wal_buffers = 64 # min 4, typically 8KB each

sort_mem = 65536 # min 64, size in KB
vacuum_mem = 65536 # min 1024, size in KB

checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 300 # range 30-3600, in seconds
#
commit_delay = 0 # range 0-100000, in microseconds
commit_siblings = 5 # range 1-1000
#
fsync = true
wal_sync_method = fsync # the default varies across platforms:
# # fsync, fdatasync, open_sync, or
open_datasync
wal_debug = 0 # range 0-16

regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de