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 9E0D45289E for ; Thu, 9 Jun 2005 06:15:24 -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 11585-06 for ; Thu, 9 Jun 2005 09:15:15 +0000 (GMT) Received: from mail.census.gov.ph (mail.census.gov.ph [203.172.28.120]) by svr1.postgresql.org (Postfix) with ESMTP id 811A852838 for ; Thu, 9 Jun 2005 06:13:11 -0300 (ADT) Received: from notnot ([192.168.1.70]) by mail.census.gov.ph (8.13.1/8.13.1) with ESMTP id j5997NkU023367 for ; Thu, 9 Jun 2005 17:07:23 +0800 Message-Id: <200506090907.j5997NkU023367@mail.census.gov.ph> From: "Michael Ryan S. Puncia" To: Subject: pg_autovacuum settings Date: Thu, 9 Jun 2005 17:19:55 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C56D17.74A7B330" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcVs1GYZSVIPXdoLS/GMM8Ey+rps2g== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-NSO-MailScanner: Found to be clean by NSO MailScanner. X-MailScanner-From: mpuncia@census.gov.ph X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.092 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200506/206 X-Sequence-Number: 12843 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C56D17.74A7B330 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, My Secenario : P4 with 1G of memory on Fedora Core about 100 inserts/update per hour about 100 query per minute 20 concurrent connections 1. What is the best parameter setting in the pg_autovacuum for my scenario ? 2. what will be my sleep setting if i want to execute pg_autovacuum only after 10 hrs after the last execution. Sorry for asking those stupid question but is this my first time to use pg_autovacuum and i can't understand the README.pg_autovacuum file :) The default parameters in pg_autovacuum.h makes my box suffer some resources problem. Thanks ------=_NextPart_000_0000_01C56D17.74A7B330 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

Hi,

 

My Secenario :

 

P4 with 1G of memory on Fedora = Core

about 100 inserts/update per = hour

about 100 query per = minute

20 concurrent = connections

 

 

1. What is the best parameter setting in the = pg_autovacuum for my scenario ?

 

2. what will be my sleep setting if i want to execute pg_autovacuum only after 10 hrs after the last = execution.

 

 

Sorry for asking those stupid question but is this my = first time to use pg_autovacuum and i can’t understand the =

README.pg_autovacuum file = :)

 

The default parameters in pg_autovacuum.h makes my = box suffer some resources problem.

 

Thanks

 

------=_NextPart_000_0000_01C56D17.74A7B330--