pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow much memory PostgreSQL is going to use?
2+ messages / 2 participants
[nested] [flat]
* How much memory PostgreSQL is going to use?
@ 2007-06-12 14:27 Arnau <arnaulist@andromeiberica.com>
0 siblings, 1 reply; 2+ messages in thread
From: Arnau @ 2007-06-12 14:27 UTC (permalink / raw)
To: pgsql-performance
Hi all,
I have a server with 4GB of memory and I'm tweaking the PostgreSQL
configuration. This server will be dedicated to run PostgreSQL so I'd
like to dedicate as much as possible RAM to it.
I have dedicated 1GB to shared_buffers (shared_buffers=131072) but
I'm not sure if this will be the maximum memory used by PostgreSQL or
additional to this it will take more memory. Because if shared_buffers
is the maximum I could raise that value even more.
Cheers!
--
Arnau
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How much memory PostgreSQL is going to use?
@ 2007-06-12 14:37 Bill Moran <wmoran@collaborativefusion.com>
parent: Arnau <arnaulist@andromeiberica.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bill Moran @ 2007-06-12 14:37 UTC (permalink / raw)
To: arnaulist@andromeiberica.com; +Cc: pgsql-performance
In response to Arnau <arnaulist@andromeiberica.com>:
> Hi all,
>
> I have a server with 4GB of memory and I'm tweaking the PostgreSQL
> configuration. This server will be dedicated to run PostgreSQL so I'd
> like to dedicate as much as possible RAM to it.
>
> I have dedicated 1GB to shared_buffers (shared_buffers=131072) but
> I'm not sure if this will be the maximum memory used by PostgreSQL or
> additional to this it will take more memory. Because if shared_buffers
> is the maximum I could raise that value even more.
Individual backend processes will allocate more memory above shared_buffers
for processing individual queries. See work_mem.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-06-12 14:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-12 14:27 How much memory PostgreSQL is going to use? Arnau <arnaulist@andromeiberica.com>
2007-06-12 14:37 ` Bill Moran <wmoran@collaborativefusion.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox