Limits to size of shared buffers?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Limits to size of shared buffers?
Дата
Msg-id ajrkjo$2ng9$1@news.hub.org
обсуждение исходный текст
Ответы Re: Limits to size of shared buffers?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Limits to size of shared buffers?  (Chris Ruprecht <chris@cdrbill.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: [SQL] Urgent - SQL Unique constraint error (long)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Limits to size of shared buffers?