X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D2D53D1DA66 for ; Wed, 11 Feb 2004 16:16:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76268-09 for ; Wed, 11 Feb 2004 12:16:42 -0400 (AST) Received: from servidor5.servidorbr.net (unknown [69.57.128.78]) by svr1.postgresql.org (Postfix) with ESMTP id 2AAACD1CE3E for ; Wed, 11 Feb 2004 12:16:43 -0400 (AST) Received: from cpanel by servidor5.servidorbr.net with local (Exim 4.24) id 1Aqx2Y-0001oj-7z for pgsql-performance@postgresql.org; Wed, 11 Feb 2004 14:16:42 -0200 Received: from 200.207.205.140 ([200.207.205.140]) by tiago.hazor.com.br (IMP) with HTTP for ; Wed, 11 Feb 2004 14:16:41 -0200 Message-ID: <1076516201.402a556a176d1@tiago.hazor.com.br> Date: Wed, 11 Feb 2004 14:16:42 -0200 From: alemon@tiago.hazor.com.br To: Postgresql Performance Subject: Re: slow database References: <1076509411.402a3ae38d9b8@tiago.hazor.com.br> <1076510965.761.17.camel@jester> In-Reply-To: <1076510965.761.17.camel@jester> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.207.205.140 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - servidor5.servidorbr.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 502] / [47 12] X-AntiAbuse: Sender Address Domain - tiago.hazor.com.br X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/130 X-Sequence-Number: 5654 the normal queries do not present problems, but all the ones that join has are very slow. OBS: I am using way ODBC. He will be that they exist some configuration specifies inside of the same bank or in the ODBC? Quoting Rod Taylor : > On Wed, 2004-02-11 at 09:23, alemon@tiago.hazor.com.br wrote: > > my data base is very slow. The machine is a processor Xeon 2GB with > > 256 MB of RAM DDR. My archive of configuration is this: > > I'm not surprised. New values below old. > > > > sort_mem = 131072 # min 64, size in KB > > sort_mem = 8192. > > > fsync = false > > Are you aware of the potential for data corruption during a hardware, > power or software failure? > > > enable_seqscan = false > > enable_indexscan = false > > enable_tidscan = false > > enable_sort = false > > enable_nestloop = false > > enable_mergejoin = false > > enable_hashjoin = false > > You want all of these set to true, not false. > > > effective_cache_size = 170000 # typically 8KB each > > effective_cache_size = 16384. > > > random_page_cost = 1000000000 # units are one sequential page fetch cost > > random_page_cost = 3 > > > cpu_tuple_cost = 0.3 # (same) > > cpu_tuple_cost = 0.01 > > > cpu_index_tuple_cost = 0.6 # (same) > > cpu_index_tuple_cost = 0.001 > > > cpu_operator_cost = 0.7 # (same) > > cpu_operator_cost = 0.0025 > > > default_statistics_target = 1 # range 1-1000 > > default_statistics_target = 10 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >