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 B135652833 for ; Wed, 22 Jun 2005 13:29:03 -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 59505-08 for ; Wed, 22 Jun 2005 16:28:57 +0000 (GMT) Received: from exobox.exoweb.net (unknown [221.122.43.98]) by svr1.postgresql.org (Postfix) with SMTP id 4F58E52825 for ; Wed, 22 Jun 2005 13:28:52 -0300 (ADT) Received: (qmail 13856 invoked from network); 22 Jun 2005 16:28:45 -0000 Received: from exo185.exoweb.net (HELO tobias.nordicbet.invalid) (192.168.0.185) by 0 with SMTP; 22 Jun 2005 16:28:45 -0000 Received: by tobias.nordicbet.invalid (Postfix, from userid 500) id 9E460E0D07; Thu, 23 Jun 2005 00:28:44 +0800 (CST) Date: Thu, 23 Jun 2005 00:28:44 +0800 From: Tobias Brox To: Kjell Tore Fossbakk Cc: pgsql-performance@postgresql.org Subject: Re: Querying 19million records very slowly Message-ID: <20050622162844.GE7839@tobias> References: <42B976D0.3000909@PresiNET.com> 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/439 X-Sequence-Number: 13076 [Kjell Tore Fossbakk - Wed at 07:41:54AM -0700] > I cant get the config file to load into my postgres. that's the > problem. I want to set it to 10k, but it is only still at 1000... I > save the file and restart the service.. > > yes, i ment 'pg_ctl reload', sry about that one. Classical problem, a bit depending on the distro you are using. The "master" file usually resides in /etc/postgresql while the actual file used usually resides in /var/lib/postgres/data ... or something. Some distros copies over the file (such that one always should edit the file in /etc) others don't (thus you either have to do that your self, or edit the file in the database data directory. -- Tobias Brox, +86-13521622905 Nordicbet, IT dept