Postgres Pro
Downloads
Home   >   mailing lists

Increasing Shared Memory size, in order to increase shared buffer size - Mailing list pgsql-admin

From Yusuf
Subject Increasing Shared Memory size, in order to increase shared buffer size
Date
Msg-id 3ECA2B8F.6080908@netscape.net
Whole thread Raw
Responses Re: Increasing Shared Memory size, in order to increase shared buffer size  (Sean Chittenden <sean@chittenden.org>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: "Kovalcik, Mike A [ITS]"
Date:
Subject: Date question....
Next
From: ivan
Date:
Subject: SECURITY