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

From: Yusuf <yusuf0478(at)netscape(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Increasing Shared Memory size, in order to increase shared buffer size
Date: 2003-05-20 13:20:15
Message-ID: 3ECA2B8F.6080908@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Netscape!
http://shopnow.netscape.com/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kris Kiger 2003-05-20 14:58:17 Table size on disk
Previous Message Dmitry Morozovsky 2003-05-20 10:22:29 logging modifying statements only