X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C7FBD8B35 for ; Thu, 8 Sep 2005 22:13:30 -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 77828-10 for ; Fri, 9 Sep 2005 01:13:26 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 063BAD8B2B for ; Thu, 8 Sep 2005 22:13:28 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 36so335468wri for ; Thu, 08 Sep 2005 18:13:32 -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:mime-version:content-type; b=PCEVy33+nROkV5cDzYa2wLsIWln8NER6g2a7UkApPc5Eifsn7GIerD3C1tmyK0ZEx35Tu0865TWxkidbqmNbbFo5iKNb+aG2B4WZSg+RpAjC2ItavD0S0YutoqfpRiyRuIU0FIsMX3IFqCRt5ucOIVf2u3ur28fbkJgONvogTgk= Received: by 10.54.1.80 with SMTP id 80mr13220wra; Thu, 08 Sep 2005 18:13:32 -0700 (PDT) Received: by 10.54.17.61 with HTTP; Thu, 8 Sep 2005 18:13:32 -0700 (PDT) Message-ID: <1c66bda805090818131b095a3@mail.gmail.com> Date: Fri, 9 Sep 2005 13:13:32 +1200 From: adey Reply-To: adey11@gmail.com To: pgsql-admin@postgresql.org Subject: Stats turned on but not being updated Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1451_22599910.1126228412656" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.716 required=5 tests=[AWL=-0.120, FROM_ENDS_IN_NUMS=0.516, HTML_10_20=0.295, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/92 X-Sequence-Number: 18829 ------=_Part_1451_22599910.1126228412656 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Please tell me what I'm missing? My stats Postgres 7.4 parameters are as follows:- stats_start_collector =3D true stats_command_string =3D true stats_block_level =3D true stats_row_level =3D true stats_reset_on_server_start =3D true After turning all of these on, I restarted Postgres, then ran a table quer= y=20 and saw statistics appear in the following view:- pg_statio_all_tables However, since that first test query yesterday (and I've run several since= =20 on different tables today - some of them repeated to ensure the buffer=20 should be populated), the statistics haven't changed. Is there another=20 parameter, or more space, or something, that I need to allocate please? Eve= n=20 the stats on the system tables don't appear to change with several users on= =20 ths system. Adrian ------=_Part_1451_22599910.1126228412656 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Please tell me what I'm missing?
My stats Postgres 7.4 parameters are as follows:-
 
stats_start_collector =3D true
stats_command_string =3D true
sta= ts_block_level =3D true
stats_row_level =3D true
stats_reset_on_serve= r_start =3D true
 
After turning all of these on, I restarted Postgres, then ran a table = query and saw statistics appear in the following view:-
 
pg_statio_all_tables
 
However, since that first test query yesterday (and I've run seve= ral since on different tables today - some of them repeated to ensure = the buffer should be populated), the statistics haven't changed. Is there a= nother parameter, or more space, or something, that I need to allocate= please? Even the stats on the system tables don't appear to change with se= veral users on ths system.
 
Adrian
------=_Part_1451_22599910.1126228412656--