Обсуждение: How much memory does postgresql require?

How much memory does postgresql itself require?  How is memory allocated?
Is memory allocated when client connections are made to specific databases
and is it released when the connection has ended?   Is ps or top the best
way to monitor memory usage?  Are there any tuning recommendations for
memory?

Specs: RH 7.2, Postgresql  7.2, Interchange 4.8.

Trying to learn Linux, Postgres and IC.

Thanks,
Jeff

Gill, Jeffrey L wrote:
> How much memory does postgresql itself require?  How is memory allocated?

Well, this is going to depend on what kind of queries you're doing, how much
data you need sift through, etc.  Databases of any useful size typically
suck a lot of memory.  I think the default shared memory size is 32MB.

> Is memory allocated when client connections are made to specific databases
> and is it released when the connection has ended?

When a connection is made, a process is created which uses memory.  When the
connection ends, the process ends and the memory is released.

> Is ps or top the best way to monitor memory usage?

Whatever you like better, they show the same thing.

> Are there any tuning recommendations for memory?

Yes.  In the manual.  On the website.

http://www.postgresql.org/   (and then choose a local mirror)

--Jeremy