Limits to size of shared buffers?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Limits to size of shared buffers?
Date: 2002-08-19 20:32:21
Message-ID: ajrkjo$2ng9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Are there any limits to the size of the shared buffers parameter (as in,
can Postgres go beyond a 2 GB size when I do something like

shared_buffers = 262144 # uses 2 GB

I had set my system shared memory to more than 2 GB, but couldn't get
this line to work (Postgres returned an error when starting up). I
backed down to

shared_buffers = 196608 # uses 1.5 GB

and everything was happy.

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Cheryl Sears 2002-08-19 20:39:35 Jobs
Previous Message Darrin Domoney 2002-08-19 19:29:03 Re: [ADMIN] [SQL] Urgent - SQL Unique constraint error (long)