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 22F1C53BF6 for ; Thu, 14 Apr 2005 13:21:04 -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 31338-01 for ; Thu, 14 Apr 2005 16:21:02 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 90F5553BF2 for ; Thu, 14 Apr 2005 13:21:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3EGKl3Z001429; Thu, 14 Apr 2005 12:20:47 -0400 (EDT) To: Dawid Kuroczko Cc: Joel Fradkin , PERFORM Subject: Re: speed of querry? In-reply-to: <758d5e7f05041409044eadfcd1@mail.gmail.com> References: <758d5e7f0504140720754c7750@mail.gmail.com> <000b01c54100$a68d2300$797ba8c0@jfradkin> <758d5e7f05041409044eadfcd1@mail.gmail.com> Comments: In-reply-to Dawid Kuroczko message dated "Thu, 14 Apr 2005 18:04:02 +0200" Date: Thu, 14 Apr 2005 12:20:47 -0400 Message-ID: <1428.1113495647@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/296 X-Sequence-Number: 11693 Dawid Kuroczko writes: > Basically it tells postgres how many values should it keep for > statistics per column. The config default_statistics_target > is the default (= used when creating table) and ALTER... is > a way to change it later. Not quite. default_statistics_target is the value used by ANALYZE for any column that hasn't had an explicit ALTER SET STATISTICS done on it. So you can change default_statistics_target and that will affect existing tables. (It used to work the way you are saying, but that was a few releases back...) regards, tom lane