X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E726852863 for ; Thu, 23 Jun 2005 12:31:24 -0300 (ADT) 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 66164-09 for ; Thu, 23 Jun 2005 15:31:19 +0000 (GMT) Received: from exobox.exoweb.net (unknown [221.122.43.98]) by svr1.postgresql.org (Postfix) with SMTP id D171452812 for ; Thu, 23 Jun 2005 12:31:16 -0300 (ADT) Received: (qmail 28537 invoked from network); 23 Jun 2005 15:31:14 -0000 Received: from exo185.exoweb.net (HELO tobias.nordicbet.invalid) (192.168.0.185) by 0 with SMTP; 23 Jun 2005 15:31:14 -0000 Received: by tobias.nordicbet.invalid (Postfix, from userid 500) id 881E5E0DB6; Thu, 23 Jun 2005 23:31:12 +0800 (CST) Date: Thu, 23 Jun 2005 23:31:12 +0800 From: Tobias Brox To: Kjell Tore Fossbakk Cc: Tobias Brox , pgsql-performance@postgresql.org Subject: Re: Querying 19million records very slowly Message-ID: <20050623153112.GS7839@tobias> References: <42B976D0.3000909@PresiNET.com> <20050622162844.GE7839@tobias> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Organization: Group Nordicbet User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/457 X-Sequence-Number: 13094 > I'm running FreeBSD 4.11, and im editing the file in > /usr/local/etc/postgresql.conf, but it doesnt help. On my system the 'live' config file resides in /var/lib/postgresql/data/postgresql.conf - maybe you have them in /usr/local/var/lib ... -- Tobias Brox, +86-13521622905 Nordicbet, IT dept