explanation about buffers and memory usage ... ?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: explanation about buffers and memory usage ... ?
Date: 2001-11-19 21:30:35
Message-ID: 20011119223035.A27073@mgc.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
just a simple question:
there are at least 4 types of buffers:
shared_buffers
sort_mem
effective_cache_size
geqo_pool_size

can you please tell me when all of this memory is used. what for, and
what's also important.
assuming that i have 16 backends spawned how much memory will it take?
shared_buffers are shared. but what about others? per backend?

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ... [enjoy the silence]
... words are meaningless and forgettable ... [depeche mode]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-11-19 21:39:07 Re: Need more speed from this.
Previous Message Martín Marqués 2001-11-19 21:28:08 Re: Need more speed from this.