Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCD4M-0002C5-7o for pgsql-performance@postgresql.org; Thu, 13 Sep 2012 17:19:14 +0000 Received: from mail.communote.com ([78.47.250.179] helo=microblog.communote.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCD4J-0004p9-UB for pgsql-performance@postgresql.org; Thu, 13 Sep 2012 17:19:13 +0000 Received: from com192492.communardo.local (unknown [192.168.49.2]) by microblog.communote.com (Postfix) with ESMTP id 6042A1C006D; Thu, 13 Sep 2012 19:19:05 +0200 (CEST) Received: from COM211.communardo.local (com211.communardo.local [192.168.49.211]) by com192492.communardo.local (Postfix) with ESMTP id 089A1260032; Thu, 13 Sep 2012 19:19:11 +0200 (CEST) Received: from COM211.communardo.local ([::1]) by COM211.communardo.local ([::1]) with mapi id 14.01.0355.002; Thu, 13 Sep 2012 19:19:10 +0200 From: Bill Martin To: Tom Lane CC: "pgsql-performance@postgresql.org" Subject: Re: Planner selects different execution plans depending on limit Thread-Topic: [PERFORM] Planner selects different execution plans depending on limit Thread-Index: Ac2RvXawgJcVhPdnSmKNmIXMJZmspAAAjcU3AATdGxE= Date: Thu, 13 Sep 2012 17:19:10 +0000 Message-ID: References: <5051F227.7090600@krogh.cc>,<26906.1347548059@sss.pgh.pa.us> In-Reply-To: <26906.1347548059@sss.pgh.pa.us> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.1.3] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/56 X-Sequence-Number: 47802 > Tom Lane writes: > He can do it without having to change his schema --- but it's the index > column, not the underlying content column, that needs its statistics > target adjusted. > regards, tom lane How can I adjust the statistics target of the index?=