X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id DE3C2CBB8B for ; Mon, 14 Jul 2003 03:34:26 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 63933-08 for ; Mon, 14 Jul 2003 03:34:50 +0000 (GMT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by svr1.postgresql.org (Postfix) with ESMTP id 24955CBB87 for ; Mon, 14 Jul 2003 00:34:23 -0300 (ADT) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id NAA22638; Mon, 14 Jul 2003 13:53:16 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3F1224E5.4040802@oasis.net.au> Date: Mon, 14 Jul 2003 13:35:01 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Chris.Wu@Sanmina-SCI.Com Cc: pgsql-performance@postgresql.org Subject: Re: How to configure the postgresql.conf files References: <000001c349b7$bc8b6280$660f19ac@ChrisWu> In-Reply-To: <000001c349b7$bc8b6280$660f19ac@ChrisWu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/212 X-Sequence-Number: 2505 Hi Chris, I suggest you read this tech. document: http://www.varlena.com/GeneralBits/ I think you'll it's the best place to start. Cheers Rudi. Chris_Wu wrote: >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 > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >