In response to Arnau <[EMAIL PROTECTED]>: > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly