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 9A513528B4 for ; Wed, 22 Jun 2005 11:41:57 -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 36458-05 for ; Wed, 22 Jun 2005 14:41:55 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by svr1.postgresql.org (Postfix) with ESMTP id C7D4552817 for ; Wed, 22 Jun 2005 11:41:51 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so58694wra for ; Wed, 22 Jun 2005 07:41:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=uk0FmkAlbIeuu0kVi2tKsju+kWZipXJCq8uXwwBdDenvsllaEVneva0Hdx3Keh2rIAGkkDZB6izmkjaxpBh5lZqAaloKV53CgHa0llBmY9QvECEfd0Ko1wtnZk5OyhjBIUZf593Iv4EAC/f6FGOLbANrCuEFYibiDR62Z2lCo6k= Received: by 10.54.149.14 with SMTP id w14mr486360wrd; Wed, 22 Jun 2005 07:41:54 -0700 (PDT) Received: by 10.54.104.3 with HTTP; Wed, 22 Jun 2005 07:41:54 -0700 (PDT) Message-ID: Date: Wed, 22 Jun 2005 07:41:54 -0700 From: Kjell Tore Fossbakk Reply-To: Kjell Tore Fossbakk To: Bricklen Anderson Subject: Re: Querying 19million records very slowly Cc: pgsql-performance@postgresql.org In-Reply-To: <42B976D0.3000909@PresiNET.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <42B976D0.3000909@PresiNET.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/435 X-Sequence-Number: 13072 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. kjell tore On 6/22/05, Bricklen Anderson wrote: > >> enable_seqscan =3D false > >> enable_indexscan =3D true > >> .. > >> effective_cache_size =3D 10000 > >> random_page_cost =3D 2 > >> .. > >> > >> I save the file, type 'pg_crl reload' then enter 'psql database'. > >> > >> argus=3D> show effective_cache_size ; > >> effective_cache_size > >> ---------------------- > >> 1000 > >> (1 row) >=20 > I assume that 'pg_crl' is a typo? That should read 'pg_ctl reload' > Also, you said that your effective_cache_size =3D 10000, yet when you SHO= W > it, > it's only 1000. A cut 'n paste error, or maybe your erroneous "pg_crl" > didn't > trigger the reload? >=20 > --=20 > _______________________________ >=20 > This e-mail may be privileged and/or confidential, and the sender does > not waive any related rights and obligations. Any distribution, use or > copying of this e-mail or the information it contains by other than an > intended recipient is unauthorized. If you received this e-mail in > error, please advise me (by return e-mail or otherwise) immediately. > _______________________________ >