Increasing Shared Memory size, in order to increase shared buffer size

Поиск
Список
Период
Сортировка
От Yusuf
Тема Increasing Shared Memory size, in order to increase shared buffer size
Дата
Msg-id 3ECA2B8F.6080908@netscape.net
обсуждение исходный текст
Ответы Re: Increasing Shared Memory size, in order to increase shared buffer size  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-admin
I want to increase the buffer size on my postgresql installation, in
order to improve the performance.

Now, when I execute top, on my FreeBSD system, the memory part shows:

Mem: 26M Active, 1062M Inact, 146M Wired, 199M Buf, 776M Free
Swap: 4080M Total, 8K Used, 4080M Free

The size of the database in PGDATA/base is 415 MB. I want to increase
the shared buffer size so that I could avoid swap pagein activities.

What should I increase the shared memory size of FreeBSD to be?  What
would be a good value for the shared buffer size?

Thanks in advance.

--
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/


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

Предыдущее
От: "Kovalcik, Mike A [ITS]"
Дата:
Сообщение: Date question....
Следующее
От: ivan
Дата:
Сообщение: SECURITY