X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 96609CBB81 for ; Mon, 14 Jul 2003 03:19:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 35228-07 for ; Mon, 14 Jul 2003 03:20:19 +0000 (GMT) Received: from camellia.sanmina.com.hk (unknown [211.96.107.86]) by svr1.postgresql.org (Postfix) with ESMTP id 5B6E5CBB80 for ; Mon, 14 Jul 2003 00:19:52 -0300 (ADT) Received: from ChrisWu ([172.25.15.102]) by camellia.sanmina.com.hk (8.11.0/8.11.2) with SMTP id h6E3KMj19289 for ; Mon, 14 Jul 2003 11:20:26 +0800 Reply-To: From: "Chris_Wu" To: Subject: How to configure the postgresql.conf files Date: Mon, 14 Jul 2003 11:26:37 +0800 Message-ID: <000001c349b7$bc8b6280$660f19ac@ChrisWu> MIME-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=RCVD_IN_RFCI X-Spam-Level: * X-Archive-Number: 200307/211 X-Sequence-Number: 2504 Hello all! I'm a new to Postgresql , I have never used it before. I am having an issue with configure the postgresql.conf file. The machine itself is a CPU= 2.66GHz P4 w/ Memory= 2G Maybe you can tell me how to configure these parameters. shared_buffers= max_fsm_relations= max_fsm_pages= max_locks_per_transaction= wal_buffers= sort_mem= vacuum_mem= wal_files= wal_sync_method= wal_debug = commit_delay = commit_siblings = checkpoint_segments = checkpoint_timeout = fsync = true enable_seqscan = enable_indexscan = enable_tidscan = enable_sort = enable_nestloop = enable_mergejoin = enable_hashjoin = ksqo = effective_cache_size = random_page_cost = cpu_tuple_cost = cpu_index_tuple_cost = cpu_operator_cost = Would you mind to send me a copy of examples .(postgresql.conf) Thanks Sincerely, Chris.Wu