X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6DEEAD7D0F for ; Fri, 9 Sep 2005 03:32:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79110-02 for ; Fri, 9 Sep 2005 06:32:22 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by svr1.postgresql.org (Postfix) with ESMTP id 2AE03D7851 for ; Fri, 9 Sep 2005 03:32:22 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 36so1745116wra for ; Thu, 08 Sep 2005 23:32:23 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=kMI3gSXb9IpSpliJk1yzWzoeg44pMx7U9LvfBzoUWEL86Pkw3BMBVNq4Ytc3eSm2PuEtptPcoML/RspwbPjI3K5I7JpJlqO1Spuae+hUZctMrNXRkEG8ivQwW1XaYatp/rb4KmNrvm98pD7BCMhXvR9OAWxBv0g6oiYOU2TgjMw= Received: by 10.54.25.77 with SMTP id 77mr16324wry; Thu, 08 Sep 2005 23:32:23 -0700 (PDT) Received: by 10.54.109.4 with HTTP; Thu, 8 Sep 2005 23:32:21 -0700 (PDT) Message-ID: <38c00bae050908233278ab6cc8@mail.gmail.com> Date: Fri, 9 Sep 2005 15:32:21 +0900 From: "Choe, Cheng-Dae" Reply-To: whitekid@gmail.com To: pgsql-performance@postgresql.org Subject: Too slow query, do you have an idea to optimize? Mime-Version: 1.0 Content-Type: text/plain; charset=EUC-KR Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/116 X-Sequence-Number: 14424 SSBuZWVkIHRvIGdlbmVyYXRlIHVudXNlZCByYW5kb20gaWQgd2l0aCBmb3JtYXQgaXMgSURbMC05 XXs0fQpzbyBpIHdyaXRlIGJlbG93IHF1ZXJ5IGJ1dCBpdCBzZWVtcyB0byBiZSB0b28gc2xvdwoK U0VMRUNUICogRlJPTSAoIAogICAgU0VMRUNUIHVzZXJfaWQgRlJPTSAoCiAgICAgICAgU0VMRUNU ICdJRCcgfHwgTFBBRChyLCA0LCAnMCcpIEFTIHVzZXJfaWQgCiAgICBGUk9NIGdlbmVyYXRlX3Nl cmllcygxLCA5OTk5KSBhcyByKSBBUyBzIAogICAgRVhDRVBUCiAgICBTRUxFQ1QgdXNlcl9pZCBG Uk9NIGFjY291bnQgKSBBUyB0IApPUkRFUiBCWSByYW5kb20oKSAKTElNSVQgMQoKYW5kIEkgZXhl Y3V0ZSBleHBsYWluIGFuYWx5emUgcXVlcnkuCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQpMaW1pdCAgKGNvc3Q9MzE4LjE3Li4zMTguMTcgcm93cz0xIHdp ZHRoPTMyKSAoYWN0dWFsCnRpbWU9NzMxLjcwMy4uNzMxLjcwNyByb3dzPTEgbG9vcHM9MSkKICAg LT4gIFNvcnQgIChjb3N0PTMxOC4xNy4uMzE4Ljk1IHJvd3M9MzEyIHdpZHRoPTMyKSAoYWN0dWFs CnRpbWU9NzMxLjY5My4uNzMxLjY5MyByb3dzPTEgbG9vcHM9MSkKICAgICAgICAgU29ydCBLZXk6 IHJhbmRvbSgpCiAgICAgICAgIC0+ICBTdWJxdWVyeSBTY2FuIHQgIChjb3N0PTI4NS43OS4uMzA1 LjI0IHJvd3M9MzEyIHdpZHRoPTMyKQooYWN0dWFsIHRpbWU9NDI0LjI5OS4uNjU5LjE5MyByb3dz PTk5OTkgbG9vcHM9MSkKICAgICAgICAgICAgICAgLT4gIFNldE9wIEV4Y2VwdCAgKGNvc3Q9Mjg1 Ljc5Li4zMDEuMzUgcm93cz0zMTEKd2lkdGg9MTYpIChhY3R1YWwgdGltZT00MjQuMjY2Li41NjYu MjU0IHJvd3M9OTk5OSBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAtPiAgU29ydCAgKGNv c3Q9Mjg1Ljc5Li4yOTMuNTcgcm93cz0zMTEyCndpZHRoPTE2KSAoYWN0dWFsIHRpbWU9NDI0LjEz OS4uNDcwLjUyOSByb3dzPTEyMTExIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAg IFNvcnQgS2V5OiB1c2VyX2lkCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBBcHBlbmQg IChjb3N0PTAuMDAuLjEwNS4yNCByb3dzPTMxMTIKd2lkdGg9MTYpIChhY3R1YWwgdGltZT01LjU3 Mi4uMjc2LjQ4NSByb3dzPTEyMTExIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBTdWJxdWVyeSBTY2FuICIqU0VMRUNUKiAxIiAKKGNvc3Q9MC4wMC4uMzAuMDAg cm93cz0xMDAwIHdpZHRoPTQpIChhY3R1YWwgdGltZT01LjU2NS4uMTQ5LjYxNQpyb3dzPTk5OTkg bG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEZ1bmN0 aW9uIFNjYW4gb24KZ2VuZXJhdGVfc2VyaWVzIHIgIChjb3N0PTAuMDAuLjIwLjAwIHJvd3M9MTAw MCB3aWR0aD00KSAoYWN0dWFsCnRpbWU9NS41NTMuLjYzLjIyNCByb3dzPTk5OTkgbG9vcHM9MSkK ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFN1YnF1ZXJ5IFNjYW4gIipTRUxF Q1QqIDIiIAooY29zdD0wLjAwLi43NS4yNCByb3dzPTIxMTIgd2lkdGg9MTYpIChhY3R1YWwgdGlt ZT0wLjAzMC4uMjguNDczCnJvd3M9MjExMiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gYWNjb3VudCAKKGNvc3Q9MC4wMC4uNTQu MTIgcm93cz0yMTEyIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMTkuLjEwLjE1NQpyb3dzPTIx MTIgbG9vcHM9MSkKVG90YWwgcnVudGltZTogNzM4LjgwOSBtcwoKCmRvIHlvdSBoYXZlIGFueSBp ZGVhIGZvciBvcHRpbWl6ZT8KLS0gCkNob2UsIENoZW5nLURhZSjD1sGktOspCkJsb2c6IGh0dHA6 Ly93d3cuY29tZG9uZ2luLmNvbS8K