Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6VVE-0001cp-7l for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2019 07:19:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6VVA-0002UI-VL for pgsql-docs@arkaria.postgresql.org; Wed, 20 Mar 2019 07:19:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6T2K-0002Wv-2g for pgsql-docs@lists.postgresql.org; Wed, 20 Mar 2019 04:41:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6T2G-00038U-CB for pgsql-docs@lists.postgresql.org; Wed, 20 Mar 2019 04:41:07 +0000 Content-Type: multipart/mixed; boundary="===============4619303202576298348==" MIME-Version: 1.0 Subject: ORDER BY LIMIT n does not work as described when using partitioned tables To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: niels@thinkiq.com Reply-To: niels@thinkiq.com, pgsql-docs@lists.postgresql.org Date: Wed, 20 Mar 2019 04:40:18 +0000 Message-ID: <155305681875.30367.2600813692413489939@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4619303202576298348== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9pbmRl eGVzLW9yZGVyaW5nLmh0bWwKRGVzY3JpcHRpb246CgpEZWFyIFBvc3RncmVzIHRlYW0sDQpGaXJz dCwgdGhhbmtzIGZvciBhbiBleGNlbGxlbnQgcHJvZHVjdCBhbmQgZ3JlYXQgZG9jdW1lbnRhdGlv bi4gVGhpcyBpcwp3b3JsZCBjbGFzcy4NCg0KV2UgaGF2ZSBmb3VuZCBhbiBpc3N1ZSB3aXRoIGlu ZGV4IGFuZCBPUkRFUiBCWSBMSU1JVCAxIHdoZW4gdXNpbmcKcGFydGl0aW9uZWQgdGFibGVzLiBU aGUgdGFibGVkIGlzIHBhcnRpdGlvbmVkIHVzaW5nIGRlY2xhcmF0aXZlCnBhcnRpdGlvbmluZywg dGhlIHBhcnRpdGlvbiBpcyBjcmVhdGVkIG9uIHRpbWVzdGFtcHR6LiBUaGVyZSBpcyBvbmUKcGFy dGl0aW9uIHBlciBkYXkuDQoNCkxvb2tpbmcgYXQgdGhlIHF1ZXJ5IHBsYW5uZXIsIGl0IGlzIGNs ZWFyIHRoYXQgaXQgaXMgdHJ5aW5nIHRvIG9wZW4gdXAgYWxsCnRoZSBpbmRleGVzICh3ZSBoYXZl IGh1bmRyZWRzIG9mIHBhcnRpdGlvbmVkIHRhYmxlcykgdG8gZmluZCB0aGUgMSByb3cgdGhhdAp3 ZSBhcmUgYXNraW5nIGZvciwgZXZlbiBpZiB0aGUgcm93IGlzIGluIHRoZSBmaXJzdCB0YWJsZSB0 aGF0IHRoZSBpbmRleApzaG91bGQgbG9vayBhdC4gDQoNClRoZSByZXN1bHQgaXMgdGhhdCB0aGUg cXVlcnkgaXMgZXh0cmVtZWx5IHNsb3cuIEFsbCB0aGUgYmVuZWZpdHMgb2YgdXNpbmcKcGFydGl0 aW9uZWQgdGFibGVzIHNlZW1zIHRvIGJlIGdvbmUsIGl0IGlzIHdvcnNlIHRoYW4gbm90IHBhcnRp dGlvbmluZy4NCg0KSSB3b3VsZCBwcmVmZXIgdGhhdCB0aGUgaXNzdWUgaXMgc29sdmVkIGluIHRo ZSBwYXJ0aXRpb25lZCB0YWJsZSwgaW4gdGhpcwpjYXNlIHRoZSBkb2N1bWVudGF0aW9uIGlzIGNv cnJlY3QuIElmIGl0IGlzIG5vdCBwb3NzaWJsZSB0byBzb2x2ZSB0aGUKcGFydGl0aW9uaW5nIGlz c3VlLCB0aGVuIHRoZSBkb2N1bWVudGF0aW9uIHNob3VsZCBiZSB1cGRhdGVkLg0KDQpIZXJlIGFy ZSB0aGUgc2NyaXB0czoNCg0KQ1JFQVRFIFRBQkxFIGhpc3RvcnkuaGlzdG9yeV9ib29scw0KKA0K ICAgIHRoaW5nX2lkIGJpZ2ludCwNCiAgICBib29sdmFsdWUgYm9vbGVhbiwNCiAgICAidGltZXN0 YW1wIiB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgTk9UIE5VTEwNCikgUEFSVElUSU9OIEJZIFJB TkdFICgidGltZXN0YW1wIikgDQpXSVRIICgNCiAgICBPSURTID0gRkFMU0UNCikNClRBQkxFU1BB Q0UgcGdfZGVmYXVsdDsNCg0KQUxURVIgVEFCTEUgaGlzdG9yeS5oaXN0b3J5X2Jvb2xzDQogICAg T1dORVIgdG8gcG9zdGdyZXM7DQoNCi0tIFBhcnRpdGlvbnMgU1FMDQoNCkNSRUFURSBUQUJMRSBo aXN0b3J5Lmhpc3RvcnlfYm9vbHNfMjAxOF8wNV8wMSBQQVJUSVRJT04gT0YKaGlzdG9yeS5oaXN0 b3J5X2Jvb2xzDQogICAgRk9SIFZBTFVFUyBGUk9NICgnMjAxOC0wNC0zMCAxNzowMDowMC0wNycp IFRPICgnMjAxOC0wNS0wMQoxNzowMDowMC0wNycpOw0KDQpDUkVBVEUgVU5JUVVFIElOREVYIGhp c3RvcnlfYm9vbHNfMjAxOF8wNV8wMV9pZHgNCiAgICBPTiBoaXN0b3J5Lmhpc3RvcnlfYm9vbHNf MjAxOF8wNV8wMSBVU0lORyBidHJlZQ0KICAgICh0aGluZ19pZCwgInRpbWVzdGFtcCIpDQogICAg VEFCTEVTUEFDRSBwZ19kZWZhdWx0Ow0KDQpDUkVBVEUgVEFCTEUgaGlzdG9yeS5oaXN0b3J5X2Jv b2xzXzIwMThfMDVfMDIgUEFSVElUSU9OIE9GCmhpc3RvcnkuaGlzdG9yeV9ib29scw0KICAgIEZP UiBWQUxVRVMgRlJPTSAoJzIwMTgtMDUtMDEgMTc6MDA6MDAtMDcnKSBUTyAoJzIwMTgtMDUtMDIK MTc6MDA6MDAtMDcnKTsNCg0KQ1JFQVRFIFVOSVFVRSBJTkRFWCBoaXN0b3J5X2Jvb2xzXzIwMThf MDVfMDJfaWR4DQogICAgT04gaGlzdG9yeS5oaXN0b3J5X2Jvb2xzXzIwMThfMDVfMDIgVVNJTkcg YnRyZWUNCiAgICAodGhpbmdfaWQsICJ0aW1lc3RhbXAiKQ0KICAgIFRBQkxFU1BBQ0UgcGdfZGVm YXVsdDsNCg0KLi4uLg0KDQpTRUxFQ1QgKiBGUk9NIGhpc3RvcnkuaGlzdG9yeV9ib29scyBXSEVS RSB0aGluZ19pZCA9IDEgQU5EICJ0aW1lc3RhbXAiIDwKJzIwMTgtMDUtMDMgMTI6MDA6MDAnOwo= --===============4619303202576298348==--