Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCAcQ-0000C8-0k for pgsql-performance@postgresql.org; Thu, 13 Sep 2012 14:42:14 +0000 Received: from mail.communote.com ([78.47.250.179] helo=microblog.communote.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCAcO-00070w-Jr for pgsql-performance@postgresql.org; Thu, 13 Sep 2012 14:42:13 +0000 Received: from com192492.communardo.local (unknown [192.168.49.2]) by microblog.communote.com (Postfix) with ESMTP id 5E11E1C006D; Thu, 13 Sep 2012 16:42:02 +0200 (CEST) Received: from COM211.communardo.local (com211.communardo.local [192.168.49.211]) by com192492.communardo.local (Postfix) with ESMTP id 08204260032; Thu, 13 Sep 2012 16:42:08 +0200 (CEST) Received: from COM211.communardo.local ([::1]) by COM211.communardo.local ([::1]) with mapi id 14.01.0355.002; Thu, 13 Sep 2012 16:42:07 +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: Ac2RvXawgJcVhPdnSmKNmIXMJZmspA== Date: Thu, 13 Sep 2012 14:42:07 +0000 Message-ID: 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/53 X-Sequence-Number: 47799 PiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+IHdyaXRlczoNCj4+IEJpbGwgTWFydGluIDxi aWxsLm1hcnRpbkBjb21tdW5vdGUuY29tPiB3cml0ZXM6DQo+PiBJJ3ZlIHRyaWVkIGRpZmZlcmVu dCB2YWx1ZXMgZm9yIHRoZSBzdGF0aXN0aWNzIGJ1dCBpdCBpcyBhbGwgdGhlIHNhbWUgKHRoZSBw bGFubmVyIGRlY2lkZSB0byBzd2l0Y2ggdG8gYSBzZXFzY2FuIGlmIHRoZSBsaW1pdCBpcyAxMCku DQoNCj4+IEFMVEVSIFRBQkxFIGNvcmVfY29udGVudCBBTFRFUiBjb2x1bW4gY29udGVudCBTRVQg U1RBVElTVElDUyAxMDAwOw0KDQo+IFVtLCBkaWQgeW91IGFjdHVhbGx5IGRvIGFuIEFOQUxZWkUg YWZ0ZXIgY2hhbmdpbmcgdGhhdD8NCj4gDQo+IAkJCXJlZ2FyZHMsIHRvbSBsYW5lDQoNClllcywg SSd2ZSBydW4gdGhlIEFOQUxZWkUgY29tbWFuZC4NCg0KUmVnYXJkcywNCkJpbGwgTWFydGluDQo=