Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id F17691F6070A for ; Fri, 9 Dec 2011 08:23:53 -0400 (AST) Received: from smtp-sofia.digsys.bg ([193.68.3.230]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYzUU-0008GD-Uo for pgsql-performance@postgresql.org; Fri, 09 Dec 2011 12:23:53 +0000 Received: from luke.digsys.bg (luke.digsys.bg [193.68.6.22]) by smtp-sofia.digsys.bg (8.14.4/8.14.4) with ESMTP id pB9CNREs066996 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 9 Dec 2011 14:23:34 +0200 (EET) (envelope-from kaloyan@digsys.bg) Message-ID: <4EE1FDC7.70601@digsys.bg> Date: Fri, 09 Dec 2011 14:23:35 +0200 From: Kaloyan Iliev Iliev Reply-To: kaloyan@digsys.bg Organization: Register.BG Ltd. User-Agent: Thunderbird 2.0.0.24 (X11/20100614) MIME-Version: 1.0 To: Tom Lane CC: pgsql-performance@postgresql.org Subject: Re: Slow query after upgrade from 8.2 to 8.4 References: <4EE0F3F4.8040909@digsys.bg> <14557.1323401295@sss.pgh.pa.us> In-Reply-To: <14557.1323401295@sss.pgh.pa.us> Content-Type: text/html; charset=windows-1251 Content-Transfer-Encoding: base64 X-MIME-Autoconverted: from 8bit to base64 by smtp-sofia.digsys.bg id pB9CNREs066996 X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201112/78 X-Sequence-Number: 45877 PCFET0NUWVBFIGh0bWwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEgVHJhbnNpdGlv bmFsLy9FTiI+DQo8aHRtbD4NCjxoZWFkPg0KICA8bWV0YSBjb250ZW50PSJ0ZXh0L2h0bWw7 Y2hhcnNldD13aW5kb3dzLTEyNTEiDQogaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIj4NCjwv aGVhZD4NCjxib2R5IGJnY29sb3I9IiNmZmZmZmYiIHRleHQ9IiMwMDAwMDAiPg0KPHR0Pkhp LDxicj4NCkFjdHVhbGx5IEkgdGhpbmsgdGhlIHByb2JsZW0gaXMgd2l0aCB0aGlzIHN1YiBx dWVyeTo8YnI+DQpleHBsYWluIGFuYWx5emUgc2VsZWN0IDE8YnI+DQqgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBmcm9tIGFjY19jbGllbnRzIEFDLDxicj4NCqCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgYWNjX2RlYnRzIEFE LDxicj4NCqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgZGVi dHNfZGVzYyBERCw8YnI+DQqgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgIGNvbmZpZyBDRjxicj4NCqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgIHdoZXJlIEFDLmlubyA9IDEyMDAwMDAgQU5EPGJyPg0KPGJyPg0KoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgQ0YuaWQgPSAoc2VsZWN0IGlk PGJyPg0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgIGZyb20gY29uZmlnPGJyPg0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgIHdoZXJlDQpjb25maWQ9Q0YuY29uZmlkIE9SREVS IEJZIGFyY2hpdmVkX2F0IERFU0MgTElNSVQgMSkgQU5EPGJyPg0KoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgQUQudHJhbnNhY3Rfbm8gPQ0KQUMudHJh bnNhY3Rfbm8gQU5EPGJyPg0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKAgQUQuZGVidGlkID0gREQuZGVidGlkIEFORDxicj4NCqCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBDRi5vZmZpY2UgPSAxOCBBTkQ8YnI+ DQqgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBERC5yZWZp ZCA9IENGLmNvbmZpZCBMSU1JVA0KMTs8L3R0Pjxicj4NCjxicj4NCkluc3RlYWQgb2Ygc3Rh cnRpbmcgZnJvbSAnPHR0PkFDLmlubyA9IDEyMDAwMDAnIGFuZKAgbGltaXQgdGhlIHJvd3Mg SVQNCnN0YXJ0IHdpdGggJzwvdHQ+PHR0PkNGLm9mZmljZSA9IDE4JyB3aGljaCByZXR1cm5z IG11Y2ggbW9yZSByb3dzOjxicj4NClNPOiBUaGlzIGlzIHRoZSBxdWVyeSBwbGFuIG9mIHRo ZSB1cHBlciBxdWVyeS48YnI+DQo8YnI+DQo8YSBjbGFzcz0ibW96LXR4dC1saW5rLWZyZWV0 ZXh0IiBocmVmPSJodHRwOi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvQVROIj5odHRwOi8vZXhw bGFpbi5kZXBlc3ouY29tL3MvQVROPC9hPjxicj4NCjxicj4NCjxicj4NCklmIEkgcmVtb3Zl IHRoZSBjb25kaXRpb24gPC90dD48dHQ+JzwvdHQ+PHR0PkNGLm9mZmljZSA9IDE4JyB0aGUN CnBsYW5uZXIgY2hvc2UgdGhlIGNvcnJlY3QgcGxhbiBhbmQgcmVzdWx0IGlzIGZhc3QuPC90 dD48YnI+DQo8dHQ+ZXhwbGFpbiBhbmFseXplIHNlbGVjdCAxPGJyPg0KoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgZnJvbSBhY2NfY2xpZW50cyBBQyw8YnI+DQqg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgIGFjY19kZWJ0cyBB RCw8YnI+DQqgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgIGRl YnRzX2Rlc2MgREQsPGJyPg0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoCBjb25maWcgQ0Y8YnI+DQqgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoCB3aGVyZSBBQy5pbm8gPSAxMjAwMDAwIEFORDxicj4NCjxicj4NCqCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgIENGLmlkID0gKHNlbGVjdCBp ZDxicj4NCqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoCBmcm9tIGNvbmZpZzxicj4NCqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCB3aGVyZQ0KY29uZmlkPUNGLmNvbmZpZCBPUkRF UiBCWSBhcmNoaXZlZF9hdCBERVNDIExJTUlUIDEpIEFORDxicj4NCqCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgIEFELnRyYW5zYWN0X25vID0NCkFDLnRy YW5zYWN0X25vIEFORDxicj4NCqCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgIEFELmRlYnRpZCA9IERELmRlYnRpZCBBTkQ8YnI+DQqgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBERC5yZWZpZCA9IENGLmNvbmZpZCBM SU1JVA0KMTs8YnI+DQo8L3R0Pjx0dD48YnI+DQo8YSBjbGFzcz0ibW96LXR4dC1saW5rLWZy ZWV0ZXh0IiBocmVmPSJodHRwOi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvNHpiIj5odHRwOi8v ZXhwbGFpbi5kZXBlc3ouY29tL3MvNHpiPC9hPjwvdHQ+PGJyPg0KPGJyPg0KSSB3YW50IHRo aXMgcGxhbiBhbmQgdGhpcyBxdWVyeSBidXQgd2l0aCB0aGUgYWRkaXRpb25hbCBjb25kaXRp b248dHQ+ICc8L3R0Pjx0dD5DRi5vZmZpY2UNCj0gMTgnLjxicj4NCkhvdyBjb3VsZCBJIGZv cmNlIHRoZSBwbGFubmVyIHRvIHVzZSB0aGlzIHBsYW4gYW5kIGp1c3QgZmlsdGVyIHRoZQ0K cmVzdWx0Ljxicj4NCjxicj4NCkJlc3QgcmVnYXJkcyw8YnI+DQqgS2Fsb3lhbiBJbGlldjxi cj4NCjwvdHQ+PGJyPg0KPGJyPg0KVG9tIExhbmUgd3JvdGU6DQo8YmxvY2txdW90ZSBjaXRl PSJtaWQ6MTQ1NTcuMTMyMzQwMTI5NUBzc3MucGdoLnBhLnVzIiB0eXBlPSJjaXRlIj4NCiAg PHByZSB3cmFwPSIiPkthbG95YW4gSWxpZXYgSWxpZXYgPGEgY2xhc3M9Im1vei10eHQtbGlu ay1yZmMyMzk2RSIgaHJlZj0ibWFpbHRvOmthbG95YW5AZGlnc3lzLmJnIj4mbHQ7a2Fsb3lh bkBkaWdzeXMuYmcmZ3Q7PC9hPiB3cml0ZXM6DQogIDwvcHJlPg0KICA8YmxvY2txdW90ZSB0 eXBlPSJjaXRlIj4NCiAgICA8cHJlIHdyYXA9IiI+V2UgcmVjZW50bHkgdXBncmFkZSBvdXIg c2VydmVyIGZyb20gUEc4LjIgdG8gOC40Lg0KLi4uDQpIZXJlIEkgd2lsbCBwb3N0IGV4cGxh aW4gYW5hbHl6ZS4gSWYgeW91IHRoaW5rIGl0IGlzIG5lY2Vzc2FyeSBJIHdpbGwgDQpwb3N0 IHRoZSBleGFjdCBxdWVyeToNCjxhIGNsYXNzPSJtb3otdHh0LWxpbmstZnJlZXRleHQiIGhy ZWY9Imh0dHA6Ly9leHBsYWluLmRlcGVzei5jb20vcy9KME8iPmh0dHA6Ly9leHBsYWluLmRl cGVzei5jb20vcy9KME88L2E+DQogICAgPC9wcmU+DQogIDwvYmxvY2txdW90ZT4NCiAgPHBy ZSB3cmFwPSIiPjwhLS0tLT4NClllYWgsIHlvdSBuZWVkIHRvIHNob3cgdGhlIHF1ZXJ5LiAg SXQgbG9va3MgbGlrZSB0aGUgcGVyZm9ybWFuY2UgcHJvYmxlbQ0KaXMgc3RlbW1pbmcgZnJv bSBhIGxvdCBvZiBzdWJzZWxlY3RzLCBidXQgaXQncyBub3QgY2xlYXIgd2h5IDguNCB3b3Vs ZA0KYmUgaGFuZGxpbmcgdGhvc2Ugd29yc2UgdGhhbiA4LjIuDQoNCgkJCXJlZ2FyZHMsIHRv bSBsYW5lDQoNCiAgPC9wcmU+DQo8L2Jsb2NrcXVvdGU+DQo8L2JvZHk+DQo8L2h0bWw+DQo=