X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7BB9053E20 for ; Mon, 9 May 2005 17:55:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91013-04 for ; Mon, 9 May 2005 20:55:37 +0000 (GMT) Received: from mta10.nationwireless.net (mta10.nationwireless.net [63.163.128.10]) by svr1.postgresql.org (Postfix) with ESMTP id EA15E5377E for ; Mon, 9 May 2005 17:55:35 -0300 (ADT) Received: from jfradkin [63.162.100.127] by mta10.nationwireless.net with ESMTP (SMTPD-8.20) id AE4802D0; Mon, 09 May 2005 16:55:36 -0400 From: "Joel Fradkin" To: "PostgreSQL Perform" Subject: Configing 8 gig box. Date: Mon, 9 May 2005 16:55:53 -0400 Message-ID: <006c01c554d9$7d701120$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006D_01C554B7.F65E7120" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.617 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: * X-Archive-Number: 200505/123 X-Sequence-Number: 12287 This is a multi-part message in MIME format. ------=_NextPart_000_006D_01C554B7.F65E7120 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Seems to be only using like 360 meg out of 7 gig free (odd thing is I = did see some used swap 4k out of 1.9) with a bunch of users (this may be = normal, but it is not going overly fast so thought I would ask). Items I modified per commandprompt.coma nd watching this list etc. =20 shared_buffers =3D 24576 work_mem =3D 32768 max_fsm_pages =3D 100000 max_fsm_relations =3D 1500 fsync =3D true wal_sync_method =3D open_sync wal_buffers =3D 2048 checkpoint_segments =3D 100=20 effective_cache_size =3D 524288 default_statistics_target =3D 250 =20 Any help is appreciated. =20 =20 =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 =20 ------=_NextPart_000_006D_01C554B7.F65E7120 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Seems to be only using like 360 meg out of 7 gig free = (odd thing is I did see some used swap 4k out of 1.9) with a bunch of users = (this may be normal, but it is not going overly fast so thought I would = ask).

Items I modified per commandprompt.coma nd watching = this list etc.

shared_buffers =3D = 24576

work_mem =3D = 32768

max_fsm_pages =3D = 100000

max_fsm_relations = =3D 1500

fsync =3D = true

wal_sync_method =3D = open_sync

wal_buffers =3D = 2048

checkpoint_segments = =3D 100

effective_cache_size =3D 524288

default_statistics_target =3D 250

Any help is = appreciated.

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida = 34243
Tel. 941-753-7111 ext 305

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

------=_NextPart_000_006D_01C554B7.F65E7120--