X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3EF349DCA40 for ; Sat, 4 Feb 2006 05:15:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86132-01 for ; Sat, 4 Feb 2006 05:15:11 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id AB09C9DCA30 for ; Sat, 4 Feb 2006 05:15:08 -0400 (AST) Received: from ns1.intersan.com.tr.intersan.com.tr (unknown [81.215.12.210]) by svr4.postgresql.org (Postfix) with ESMTP id B29A65AF86C for ; Sat, 4 Feb 2006 09:15:10 +0000 (GMT) Received: from alp-leptop.intersan.com.tr (unknown [212.175.96.142]) by ns1.intersan.com.tr.intersan.com.tr (Postfix) with ESMTP id BDF1E3FF5B for ; Sat, 4 Feb 2006 11:15:04 +0200 (EET) Message-Id: <6.2.1.2.2.20060204110331.03dc2eb0@81.215.12.210> X-Mailer: QUALCOMM Windows Eudora Version 6.2.1.2 Date: Sat, 04 Feb 2006 11:14:58 +0200 To: pgsql-admin@postgresql.org From: Alp UYANIK Subject: autovacuum Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.151 required=5 tests=[RCVD_IN_WHOIS_INVALID=2.151] X-Spam-Score: 2.151 X-Spam-Level: ** X-Archive-Number: 200602/35 X-Sequence-Number: 20456 i have PostgreSQL 8.1.2 i want to enable autovacuum at my PostgreSQL 8.1.2 from postgresql.conf i've got 50-60 insert and/or update queries in a second in that case tables shouldn't be locked does autovacuum locks tables while vacuuming? and also i wonder what should be the configuration? memory: 2gb ddr2 CPU: P4-prescott 3193.495 MHz cache size : 2048 KB Alp UYANIK Software Engineer