X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 43574D9A92 for ; Mon, 10 Oct 2005 05:40:04 -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 87064-08 for ; Mon, 10 Oct 2005 08:40:01 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id B4B9ED7F3F for ; Mon, 10 Oct 2005 05:40:01 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 6E4853498E for ; Mon, 10 Oct 2005 11:24:00 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30889-05 for ; Mon, 10 Oct 2005 11:23:59 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 539603176B for ; Mon, 10 Oct 2005 11:23:59 +0300 (EEST) Message-ID: <006f01c5cd76$2b166490$0b00a8c0@forge> From: "Andy" To: Subject: Server misconfiguration??? Date: Mon, 10 Oct 2005 11:39:45 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C5CD8F.4FD95DF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.313 required=5 tests=[AWL=0.235, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/157 X-Sequence-Number: 14925 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C5CD8F.4FD95DF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi to all,=20 I have the following configuration: Dual Xeon 2.8 Ghz, 1G RAM and postgre 8.0.3 installed. Modified configuration parameters: max_connections =3D 100=20 shared_buffers =3D 64000 # 500MB =3D 500 x 1024 x 1024 / (8 x 1024) = (8KB) work_mem =3D 51200 # 50MB =3D 50 x 1024 KB maintenance_work_mem =3D 102400 # 50MB =3D 100 x 1024 KB=20 checkpoint_segments =3D 10 effective_cache_size =3D 25600 # 200MB =3D 50 x 1024 / 8=20 client_min_messages =3D notice=20 log_min_messages =3D notice log_min_duration_statement =3D 2000 I get the feeling the server is somehow missconfigured or it does not = work at full parameter. If I look at memory allocation, it never goes = over 250MB whatever I do with the database. The kernel shmmax is set to = 600MB. Database Size is around 550MB.=20 Need some advise.=20 Thanks.=20 Andy. ------=_NextPart_000_006A_01C5CD8F.4FD95DF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi to all,

I have the following = configuration:

Dual Xeon 2.8 Ghz, 1G RAM and postgre = 8.0.3=20 installed.

Modified configuration = parameters:

max_connections =3D 100

shared_buffers =3D 64000 # = 500MB =3D 500 x=20 1024 x 1024 / (8 x 1024) (8KB)
work_mem =3D 51200 # 50MB = =3D 50 x 1024=20 KB
maintenance_work_mem =3D 102400 # 50MB =3D 100 x 1024 KB =

checkpoint_segments =3D 10

effective_cache_size =3D 25600 # = 200MB =3D 50 x=20 1024 / 8

client_min_messages =3D = notice

log_min_messages =3D = notice

log_min_duration_statement =3D = 2000

I get the feeling the server is somehow = missconfigured or it does not work at full parameter. If I look at = memory=20 allocation, it never goes over 250MB whatever I do with the = database. The=20 kernel shmmax is set to 600MB. Database Size is around 550MB. =

Need some advise.

Thanks.

Andy.

------=_NextPart_000_006A_01C5CD8F.4FD95DF0--