Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TDsES-00023W-KS for pgsql-performance@postgresql.org; Tue, 18 Sep 2012 07:28:32 +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 1TDsEN-0002Xp-Un for pgsql-performance@postgresql.org; Tue, 18 Sep 2012 07:28:31 +0000 Received: from com192492.communardo.local (unknown [192.168.49.2]) by microblog.communote.com (Postfix) with ESMTP id DFD2A1C0060; Tue, 18 Sep 2012 09:28:19 +0200 (CEST) Received: from COM211.communardo.local (com211.communardo.local [192.168.49.211]) by com192492.communardo.local (Postfix) with ESMTP id B7BD9260032; Tue, 18 Sep 2012 09:28:25 +0200 (CEST) Received: from COM211.communardo.local ([::1]) by COM211.communardo.local ([::1]) with mapi id 14.01.0355.002; Tue, 18 Sep 2012 09:28:25 +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: Ac2RvXawgJcVhPdnSmKNmIXMJZmspAAAjcU3AATdGxH//+PvgP/4ruAw Date: Tue, 18 Sep 2012 07:28:25 +0000 Message-ID: References: <5051F227.7090600@krogh.cc>,<26906.1347548059@sss.pgh.pa.us> <16905.1347557599@sss.pgh.pa.us> In-Reply-To: <16905.1347557599@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: [10.10.0.37] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/83 X-Sequence-Number: 47829 VG9tIExhbmUgPG1haWx0bzp0Z2xAc3NzLnBnaC5wYS51cz4gd3JpdGVzOg0KPiBCaWxsIE1hcnRp biA8YmlsbC5tYXJ0aW5AY29tbXVub3RlLmNvbT4gd3JpdGVzOg0KPj4gVG9tIExhbmUgPHRnbEBz c3MucGdoLnBhLnVzPiB3cml0ZXM6DQo+Pj4gSGUgY2FuIGRvIGl0IHdpdGhvdXQgaGF2aW5nIHRv IGNoYW5nZSBoaXMgc2NoZW1hIC0tLSBidXQgaXQncyB0aGUgDQo+Pj4gaW5kZXggY29sdW1uLCBu b3QgdGhlIHVuZGVybHlpbmcgY29udGVudCBjb2x1bW4sIHRoYXQgbmVlZHMgaXRzIA0KPj4+IHN0 YXRpc3RpY3MgdGFyZ2V0IGFkanVzdGVkLg0KDQo+PiBIb3cgY2FuIEkgYWRqdXN0IHRoZSBzdGF0 aXN0aWNzIHRhcmdldCBvZiB0aGUgaW5kZXg/DQoNCj4gSnVzdCBwcmV0ZW5kIGl0J3MgYSB0YWJs ZS4NCg0KPglBTFRFUiBUQUJMRSBpbmRleF9uYW1lIEFMVEVSIENPTFVNTiBjb2x1bW5fbmFtZSBT RVQgU1RBVElTVElDUyAuLi4NCg0KPiBZb3UnbGwgbmVlZCB0byBsb29rIGF0IHRoZSBpbmRleCAo ZWcgd2l0aCBcZCkgdG8gc2VlIHdoYXQgdGhlIG5hbWUgb2YgdGhlIGRlc2lyZWQgY29sdW1uIGlz LCBzaW5jZSBpbmRleCBleHByZXNzaW9ucyBoYXZlIHN5c3RlbS1hc3NpZ25lZA0KPiBjb2x1bW4g bmFtZXMuDQoNCj4JCXJlZ2FyZHMsIHRvbSBsYW5lDQoNCkkgdHJpZWQ6IA0KQUxURVIgVEFCTEUg ZnRfc2ltcGxlX2NvcmVfY29udGVudF9jb250ZW50X2lkeCBBTFRFUiBjb2x1bW4gdG9fdHN2ZWN0 b3IgU0VUIFNUQVRJU1RJQ1MgMTAwMDA7DQpBTkFMWVpFOw0KDQphbmQNClJFSU5ERVggSU5ERVgg ZnRfc2ltcGxlX2NvcmVfY29udGVudF9jb250ZW50X2lkeDsNCg0KQWxsIHRoZSB0cm91YmxlIHdh cyBmb3Igbm90aGluZy4NCg0KQXJlIHRoZXJlIGFueSBvdGhlciBwb3NzaWJpbGl0aWVzIHRvIHNv bHZlIG15IHByb2JsZW0/DQoNCkJlc3QgcmVnYXJkcywNCkJpbGwgTWFydGluDQo=