Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TB4xD-0004TX-Um for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 14:27:12 +0000 Received: from mout0.freenet.de ([2001:748:100:40::2:2]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TB4xC-0003gT-1v for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 14:27:11 +0000 Received: from [195.4.92.140] (helo=mjail0.freenet.de) by mout0.freenet.de with esmtpa (ID bill_martin@freenet.de) (port 25) (Exim 4.76 #1) id 1TB4x9-00024j-7j for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 16:27:07 +0200 Received: from localhost ([::1]:48056 helo=mjail0.freenet.de) by mjail0.freenet.de with esmtpa (ID bill_martin@freenet.de) (Exim 4.76 #1) id 1TB4x9-0002PP-3g for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 16:27:07 +0200 Received: from [195.4.92.10] (port=51291 helo=0.mx.freenet.de) by mjail0.freenet.de with esmtpa (ID bill_martin@freenet.de) (Exim 4.76 #1) id 1TB4uc-0001UB-P2 for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 16:24:30 +0200 Received: from web6.emo.freenet-rz.de ([194.97.107.219]:32889) by 0.mx.freenet.de with esmtpa (ID bill_martin@freenet.de) (port 587) (Exim 4.76 #1) id 1TB4uc-0006kr-MS for pgsql-performance@postgresql.org; Mon, 10 Sep 2012 16:24:30 +0200 Received: from localhost ([127.0.0.1] helo=emo.freenet.de) by web6.emo.freenet-rz.de with esmtpa (Exim 4.69 1 (Panther_1)) id 1TB4uc-0008Lx-87 for ; Mon, 10 Sep 2012 16:24:30 +0200 Date: Mon, 10 Sep 2012 16:24:30 +0200 Received: from [195.243.59.178] by web6.emo.freenet-rz.de with http; Mon, 10 Sep 2012 16:24:30 +0200 From: bill_martin@freenet.de Subject: Planner selects different execution plans depending on limit To: pgsql-performance@postgresql.org X-Priority: 3 MIME-Version: 1.0 X-Abuse: 706192422 / 195.243.59.178 Message-Id: User-Agent: freenetMail Content-Type: multipart/alternative; boundary="emo_01_34c2e4df379d0a6120bcda056157efc6" X-Pg-Spam-Score: -0.4 (/) X-Archive-Number: 201209/31 X-Sequence-Number: 47777 --emo_01_34c2e4df379d0a6120bcda056157efc6 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGkgQWxsCgpJwrR2ZSAgZnRfc2ltcGxlX2NvcmVfY29udGVudF9jb250ZW50X2lkeArCoCBPTiBj b3JlX2NvbnRlbnQKwqAgVVNJTkcgZ2luCsKgICh0b190c3ZlY3Rvcignc2ltcGxlJzo6cmVnY29u ZmlnLCBjb250ZW50KSApOwoKwqAgCklmIEnCtG0gc2VhY2hpbmcgZm9yIGEgd29yZCB3aGljaCBp cyBOT1QgaW4gdGhlIGNvbHVtbiBjb250ZW50IHRoZSBxdWVyeSBwbGFuIGFuZCB0aGUgZXhlY3V0 aW9uIHRpbWUgZGlmZmVycyB3aXRoIHRoZSBnaXZlbiBsaW1pdC4KSWYgSSBjaG9vc2UgMzkyNyBv ciBhbnkgaGlnaGVyIG51bWJlciB0aGUgcXVlcnkgZXhlY3V0aW9uIHRvb2sgb25seSBmZXcgbWls bGlzZWNvbmRzLiAKwqAgCiBjb3JlX2NvbnRlbnQgY29udGVudCB3aGVyZQp0b190c3ZlY3Rvcign c2ltcGxlJywgY29udGVudC5jb250ZW50KSBAQCB0c3F1ZXJ5KHBsYWludG9fdHNxdWVyeSgnc2lt cGxlJywgJ2FzZGFzZGFkYXMnKSA6OiB2YXJjaGFyIHx8ICc6KicpPXRydWUKTGltaXQgMzkyNwoK IkxpbWl0wqAgKGNvc3Q9MC4wMC4uMTkzMDIuMjMgcm93cz0zOTI2IHdpZHRoPTYyMSkgKGFjdHVh bCB0aW1lPTUyMTQ3LjE0OS4uNTIxNDcuMTQ5IHJvd3M9MCBsb29wcz0xKSIKIsKgIC0+wqAgU2Vx IFNjYW4gb24gY29yZV9jb250ZW50IGNvbnRlbnTCoCAoY29zdD0wLjAwLi45ODM4NC4zNCByb3dz PTIwMDExIHdpZHRoPTYyMSkgKGFjdHVhbCB0aW1lPTUyMTQ3LjE0Ny4uNTIxNDcuMTQ3IHJvd3M9 MCBsb29wcz0xKSIKIsKgwqDCoMKgwqDCoMKgIEZpbHRlcjogKHRvX3RzdmVjdG9yKCdzaW1wbGUn OjpyZWdjb25maWcsIGNvbnRlbnQpIEBAICcnJ2FzZGFzZGFkYXMnJzoqJzo6dHNxdWVyeSkiCiJU b3RhbCBydW50aW1lOiA1MjE0Ny4xNzMgbXMiCgpJcyB0aGVyZSBhbnkgcG9zaWJpbGl0eSB0byBp bXByb3ZlIHRoZSBwZXJmb3JtYW5jZSBldmVuIGlmIHRoZSBsaW1pdCBpcyBvbmx5IDEwPyBJcyBp dCBwb3NzaWJsZSB0byBkZXRlcm1pbmUgdGhhdCB0aGUgcXVlcnkgb3B0aW1pemVyIHRha2VzIG9u bHkgdGhlIGZhc3QgYml0bWFwIGhlYXAgc2NhbiBpbnN0ZWFkIG9mIHRoZSBzbG93IHNlcSBzY2Fu PwoKUmVnYXJkcywKQmlsbCBNYXJ0aW4KCgotLS0KRS1NYWlsIGlzdCBkYSB3byBkdSBiaXN0ISBK ZXR6dCBtaXQgZnJlZW5ldE1haWwgZ2FueiBiZXF1ZW0gYXVjaCB1bnRlcndlZ3MgRS1NYWlscyB2 ZXJzY2hpY2tlbi4KQW0gYmVzdGVuIGdsZWljaCBpbmZvcm1pZXJlbiB1bnRlciBodHRwOi8vbWFp bC5mcmVlbmV0LmRlL21vYmlsZS1lbWFpbC9pbmRleC5odG1s --emo_01_34c2e4df379d0a6120bcda056157efc6 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0RFIj48SFRNTD48SEVBRD48TUVUQSBIVFRQLUVRVUlWPSJDb250ZW50LVR5cGUiIENPTlRFTlQ9 InRleHQvaHRtbDsgY2hhcnNldD11cy1hc2NpaSI+PFRJVExFPjwvVElUTEU+PC9IRUFEPjxCT0RZ PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmO2ZvbnQt c2l6ZToxMHB0OyI+PHAgc3R5bGU9Im1hcmdpbjowcHg7cGFkZGluZzowcHg7Ij5IaSBBbGw8YnIg Lz48YnIgLz5JJiMxODA7dmUgIGZ0X3NpbXBsZV9jb3JlX2NvbnRlbnRfY29udGVudF9pZHg8YnIg Lz4mIzE2MDsgT04gY29yZV9jb250ZW50PGJyIC8+JiMxNjA7IFVTSU5HIGdpbjxiciAvPiYjMTYw OyAodG9fdHN2ZWN0b3IoJ3NpbXBsZSc6OnJlZ2NvbmZpZywgY29udGVudCkgKTs8YnIgLz48YnIg Lz4mIzE2MDsgPGJyIC8+SWYgSSYjMTgwO20gc2VhY2hpbmcgZm9yIGEgd29yZCB3aGljaCBpcyBO T1QgaW4gdGhlIGNvbHVtbiBjb250ZW50IHRoZSBxdWVyeSBwbGFuIGFuZCB0aGUgZXhlY3V0aW9u IHRpbWUgZGlmZmVycyB3aXRoIHRoZSBnaXZlbiBsaW1pdC48YnIgLz5JZiBJIGNob29zZSAzOTI3 IG9yIGFueSBoaWdoZXIgbnVtYmVyIHRoZSBxdWVyeSBleGVjdXRpb24gdG9vayBvbmx5IGZldyBt aWxsaXNlY29uZHMuIDxiciAvPiYjMTYwOyA8YnIgLz4gY29yZV9jb250ZW50IGNvbnRlbnQgd2hl cmU8YnIgLz50b190c3ZlY3Rvcignc2ltcGxlJywgY29udGVudC5jb250ZW50KSBAQCB0c3F1ZXJ5 KHBsYWludG9fdHNxdWVyeSgnc2ltcGxlJywgJ2FzZGFzZGFkYXMnKSA6OiB2YXJjaGFyIHx8ICc6 KicpPXRydWU8YnIgLz5MaW1pdCAzOTI3PGJyIC8+PGJyIC8+IkxpbWl0JiMxNjA7IChjb3N0PTAu MDAuLjE5MzAyLjIzIHJvd3M9MzkyNiB3aWR0aD02MjEpIChhY3R1YWwgdGltZT01MjE0Ny4xNDku LjUyMTQ3LjE0OSByb3dzPTAgbG9vcHM9MSkiPGJyIC8+IiYjMTYwOyAtPiYjMTYwOyBTZXEgU2Nh biBvbiBjb3JlX2NvbnRlbnQgY29udGVudCYjMTYwOyAoY29zdD0wLjAwLi45ODM4NC4zNCByb3dz PTIwMDExIHdpZHRoPTYyMSkgKGFjdHVhbCB0aW1lPTUyMTQ3LjE0Ny4uNTIxNDcuMTQ3IHJvd3M9 MCBsb29wcz0xKSI8YnIgLz4iJiMxNjA7JiMxNjA7JiMxNjA7JiMxNjA7JiMxNjA7JiMxNjA7JiMx NjA7IEZpbHRlcjogKHRvX3RzdmVjdG9yKCdzaW1wbGUnOjpyZWdjb25maWcsIGNvbnRlbnQpIEBA ICcnJ2FzZGFzZGFkYXMnJzoqJzo6dHNxdWVyeSkiPGJyIC8+IlRvdGFsIHJ1bnRpbWU6IDUyMTQ3 LjE3MyBtcyI8YnIgLz48YnIgLz5JcyB0aGVyZSBhbnkgcG9zaWJpbGl0eSB0byBpbXByb3ZlIHRo ZSBwZXJmb3JtYW5jZSBldmVuIGlmIHRoZSBsaW1pdCBpcyBvbmx5IDEwPyBJcyBpdCBwb3NzaWJs ZSB0byBkZXRlcm1pbmUgdGhhdCB0aGUgcXVlcnkgb3B0aW1pemVyIHRha2VzIG9ubHkgdGhlIGZh c3QgYml0bWFwIGhlYXAgc2NhbiBpbnN0ZWFkIG9mIHRoZSBzbG93IHNlcSBzY2FuPzxiciAvPjxi ciAvPlJlZ2FyZHMsPC9wPg0KPHAgc3R5bGU9Im1hcmdpbjowcHg7cGFkZGluZzowcHg7Ij5CaWxs IE1hcnRpbjwvcD48L2Rpdj48YnI+PGJyPi0tLTxicj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTph cmlhbDtmb250LXNpemU6MTBwdDsiPjxiPkUtTWFpbCBpc3QgZGEgd28gZHUgYmlzdCE8L2I+IEpl dHp0IG1pdCBmcmVlbmV0TWFpbCBnYW56IGJlcXVlbSBhdWNoIHVudGVyd2VncyBFLU1haWxzIHZl cnNjaGlja2VuLjxicj5BbSBiZXN0ZW4gZ2xlaWNoIGluZm9ybWllcmVuIHVudGVyIDxhIHN0eWxl PSJmb250LWZhbWlseTphcmlhbDtmb250LXNpemU6MTBwdDsiIGhyZWY9Imh0dHA6Ly9tYWlsLmZy ZWVuZXQuZGUvbW9iaWxlLWVtYWlsL2luZGV4Lmh0bWwiIHRhcmdldD0iX2JsYW5rIj5odHRwOi8v bWFpbC5mcmVlbmV0LmRlL21vYmlsZS1lbWFpbC9pbmRleC5odG1sPC9hPjwvZGl2PjwvQk9EWT48 L0hUTUw+ --emo_01_34c2e4df379d0a6120bcda056157efc6--