(scrap my previous internal email (hence fake) address this one is correct : sorry for that)
You can stop pgsql, start it and then watch out for the increase in SEGSZ values. I pretty much think they are in
bytes.
I am pretty confident that this value depicts the shared_buffers size in bytes.
On Δευ 05 Νοε 2012 13:14:37 Achilleas Mantzios wrote:
>
> ipcs in FreeBSD is a little ... tricky.
>
> ipcs -M
> ipcs -m
> ipcs -am
>
> could be your friends
>
> On Δευ 05 Νοε 2012 11:22:46 Frank Broniewski wrote:
> > Hi,
> >
> > I am running a PostgreSQL server on FreeBSD. The system has 32GB memory.
> > Usually I use top to examine the memory usage of the system. After a
> > while, a part, approximately 5GB, vanish from top, so that the memory
> > rounds up to 27GB. After restarting PostgreSQL, I have all 32GB again
> > available, but then it's already slightly decreasing. It's a standalone
> > database server. It has an OpenStreetMap world database running with
> > 353GB data (with indices).
> >
> > Some system information:
> > # uname -r
> > 9.0-RELEASE-p3
> > # pg_ctl --version
> > pg_ctl (PostgreSQL) 9.1.6
> >
> > # cat /boot/loader.conf
> > ...
> > kern.ipc.semmni=256
> > kern.ipc.semmns=512
> > kern.ipc.semmnu=256
> > kern.ipc.semumr=200
> > vm.pmap.shpgperproc=400
> > vm.pmap.pv_entry_max=50331648
> > ...
> >
> > # cat /pgdata/data/postgresql.conf
> > ...
> > default_statistics_target = 50 # pgtune wizard 2012-04-04
> > maintenance_work_mem = 4GB # pgtune wizard 2012-04-04
> > constraint_exclusion = on # pgtune wizard 2012-04-04
> > checkpoint_completion_target = 0.9 # pgtune wizard 2012-04-04
> > effective_cache_size = 24GB # pgtune wizard 2012-04-04
> > work_mem = 768MB # pgtune wizard 2012-04-04
> > wal_buffers = 16MB # pgtune wizard 2012-04-04
> > checkpoint_segments = 60 # 20
> > shared_buffers = 8GB # pgtune wizard 2012-04-04
> > max_connections = 100
> > synchronous_commit = off
> >
> >
> > So any help finding out why my system "looses" some RAM is greatly
> > appreciated :-) If more information is needed I will gladly provide it.
> >
> > Frank
> >
> >
> >
> >
> -
> Achilleas Mantzios
> IT DEPT
>
>
>
-
Achilleas Mantzios
IT DEPT