X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BB36D32A2A0 for ; Fri, 1 Oct 2004 20:39:42 +0100 (BST) 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 26035-02 for ; Fri, 1 Oct 2004 19:39:32 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CD96332A1E2 for ; Fri, 1 Oct 2004 20:39:33 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i91JdV5a026854 for ; Fri, 1 Oct 2004 19:39:31 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i91JEHwd086951 for pgsql-admin@postgresql.org; Fri, 1 Oct 2004 19:14:17 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: PLEASE GOD HELP US! Date: Fri, 01 Oct 2004 21:13:55 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 77 Message-ID: <415DAC73.6040404@bigfoot.com> References: <002801c4a7d0$66797ad0$3402a8c0@shanepc> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Shane|SkinnyCorp User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en In-Reply-To: <002801c4a7d0$66797ad0$3402a8c0@shanepc> X-Enigmail-Version: 0.86.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/26 X-Sequence-Number: 15020 Shane | SkinnyCorp wrote: > # PGSQL Version 7.4.2 Upgrade to 7.4.5 > #--------------------------------------------------------------------------- > # RESOURCE USAGE (except WAL) > > #--------------------------------------------------------------------------- > # - Memory - > shared_buffers = 8192 > sort_mem = 8192 > vacuum_mem = 127072 Here vacuum_mem is too high, memory wasted, if you do regular vacuum or you use the autovacuum daemon then usualy 32MB are enough > # - Free Space Map - > max_fsm_pages = 50000 # min max_fsm_relations*16, 6 bytes each > max_fsm_relations = 1000 # min 100, ~50 bytes each you didn't show us the result of vacuum full verbose so I can not tell you if they are enough or not. > enable_seqscan = false enable_seqscan = true Do you think that an index scan is always worst then a seqscan ? > random_page_cost = 4 # units are one sequential page fetch cost decrease this value to 2.5 > # - Query/Index Statistics Collector - > > stats_start_collector = false > stats_command_string = false > stats_block_level = false > stats_row_level = false > stats_reset_on_server_start = false I suggest you to start the collectors stats_start_collector = true stats_command_string = true stats_block_level = true stats_row_level = true stats_reset_on_server_start = false Regards Gaetano Mendola