X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1C44FD1B8E3 for ; Wed, 3 Sep 2003 20:44:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 42262-10 for ; Wed, 3 Sep 2003 17:44:23 -0300 (ADT) Received: from host2.hostseguro.com (unknown [200.198.188.133]) by svr1.postgresql.org (Postfix) with ESMTP id 557A1D1B8BE for ; Wed, 3 Sep 2003 17:44:20 -0300 (ADT) Received: from cpanel by host2.hostseguro.com with local (Exim 4.20) id 19ueU8-0004Yn-4s; Wed, 03 Sep 2003 17:44:12 -0300 Received: from 200.203.32.16 ([200.203.32.16]) by sistemica.info (IMP) with HTTP for ; Wed, 3 Sep 2003 17:44:12 -0300 Message-ID: <1062621852.3f56529c186db@sistemica.info> Date: Wed, 3 Sep 2003 17:44:12 -0300 From: Rhaoni Chiu Pereira To: creid Cc: PostgreSQL Performance Subject: Re: [ADMIN] SQL slower when running for the second time References: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="-MOQ1062621852172764d69df60a690f4a054550b71562" User-Agent: Internet Messaging Program (IMP) 3.2.1 X-Originating-IP: 200.203.32.16 X-MailScanner-Information: Verificado pelo McAfee VirusScan / Scanned by McAfee VirusScan X-MailScanner: Nao infectado / Found to be clean X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - host2.hostseguro.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32001 32001] / [47 12] X-AntiAbuse: Sender Address Domain - sistemica.info X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/30 X-Sequence-Number: 3396 This message is in MIME format. ---MOQ1062621852172764d69df60a690f4a054550b71562 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit <> Version of PostgreSQL? 7.3.2-3 on RedHat 9 <> <> Standard server configuration? Follow atached <> Hardware configuration? P4 1.7 Ghz 512 MB RAM DDR HD 20 GB 7200 RPM <> -----Original Message----- <> From: pgsql-admin-owner@postgresql.org <> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Rhaoni Chiu <> Pereira <> Sent: Wednesday, September 03, 2003 3:16 PM <> To: PostgreSQL Performance; Lista PostgreSQL <> Subject: [ADMIN] SQL slower when running for the second time <> <> <> Hi List, <> <> I trying to increase performance in my PostgreSQL but there is something <> wrong. when I run this SQL for the first time it takes 1 min. 40 seconds <> to <> return, but when I run it for the second time it takes more than 2 minutes, <> and <> I should retunr faster than the first time. <> <> Does anyone have a advice ? <> <> Atenciosamente, <> <> Rhaoni Chiu Pereira <> Sistêmica Computadores <> <> Visite-nos na Web: http://sistemica.info <> Fone/Fax : +55 51 3328 1122 <> <> <> <> <> <> <> ---------------------------(end of broadcast)--------------------------- <> TIP 6: Have you searched our list archives? <> <> http://archives.postgresql.org <> <> ---MOQ1062621852172764d69df60a690f4a054550b71562 Content-Type: application/octet-stream; name="postgresql.conf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="postgresql.conf" IwojIFBvc3RncmVTUUwgY29uZmlndXJhdGlvbiBmaWxlCiMgLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0KIwojIFRoaXMgZmlsZSBjb25zaXN0cyBv ZiBsaW5lcyBvZiB0aGUgZm9ybToKIwojICAgbmFtZSA9IHZhbHVlCiMKIyAo VGhlICc9JyBpcyBvcHRpb25hbC4pIFdoaXRlIHNwYWNlIG1heSBiZSB1c2Vk LiBDb21tZW50cyBhcmUgaW50cm9kdWNlZAojIHdpdGggJyMnIGFueXdoZXJl IG9uIGEgbGluZS4gVGhlIGNvbXBsZXRlIGxpc3Qgb2Ygb3B0aW9uIG5hbWVz IGFuZAojIGFsbG93ZWQgdmFsdWVzIGNhbiBiZSBmb3VuZCBpbiB0aGUgUG9z dGdyZVNRTCBkb2N1bWVudGF0aW9uLiBUaGUKIyBjb21tZW50ZWQtb3V0IHNl dHRpbmdzIHNob3duIGluIHRoaXMgZmlsZSByZXByZXNlbnQgdGhlIGRlZmF1 bHQgdmFsdWVzLgojCiMgQW55IG9wdGlvbiBjYW4gYWxzbyBiZSBnaXZlbiBh cyBhIGNvbW1hbmQgbGluZSBzd2l0Y2ggdG8gdGhlCiMgcG9zdG1hc3Rlciwg ZS5nLiAncG9zdG1hc3RlciAtYyBsb2dfY29ubmVjdGlvbnM9b24nLiBTb21l IG9wdGlvbnMKIyBjYW4gYmUgY2hhbmdlZCBhdCBydW4tdGltZSB3aXRoIHRo ZSAnU0VUJyBTUUwgY29tbWFuZC4KIwojIFRoaXMgZmlsZSBpcyByZWFkIG9u IHBvc3RtYXN0ZXIgc3RhcnR1cCBhbmQgd2hlbiB0aGUgcG9zdG1hc3Rlcgoj IHJlY2VpdmVzIGEgU0lHSFVQLiBJZiB5b3UgZWRpdCB0aGUgZmlsZSBvbiBh IHJ1bm5pbmcgc3lzdGVtLCB5b3UgaGF2ZSAKIyB0byBTSUdIVVAgdGhlIHBv c3RtYXN0ZXIgZm9yIHRoZSBjaGFuZ2VzIHRvIHRha2UgZWZmZWN0LCBvciB1 c2UgCiMgInBnX2N0bCByZWxvYWQiLgoKCiM9PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT0KCgojCiMJQ29ubmVjdGlvbiBQYXJhbWV0ZXJzCiMKdGNwaXBf c29ja2V0ID0gdHJ1ZQojc3NsID0gZmFsc2UKCm1heF9jb25uZWN0aW9ucyA9 IDMyCiNzdXBlcnVzZXJfcmVzZXJ2ZWRfY29ubmVjdGlvbnMgPSAyCgpwb3J0 ID0gNTQzMiAKI2hvc3RuYW1lX2xvb2t1cCA9IGZhbHNlCiNzaG93X3NvdXJj ZV9wb3J0ID0gZmFsc2UKCiN1bml4X3NvY2tldF9kaXJlY3RvcnkgPSAnJwoj dW5peF9zb2NrZXRfZ3JvdXAgPSAnJwojdW5peF9zb2NrZXRfcGVybWlzc2lv bnMgPSAwNzc3CSMgb2N0YWwKCiN2aXJ0dWFsX2hvc3QgPSAnJwoKI2tyYl9z ZXJ2ZXJfa2V5ZmlsZSA9ICcnCgoKIwojCVNoYXJlZCBNZW1vcnkgU2l6ZQoj CnNoYXJlZF9idWZmZXJzID0gODAwMAkJIyBtaW4gbWF4X2Nvbm5lY3Rpb25z KjIgb3IgMTYsIDhLQiBlYWNoCiNtYXhfZnNtX3JlbGF0aW9ucyA9IDEwMDAJ IyBtaW4gMTAsIGZzbSBpcyBmcmVlIHNwYWNlIG1hcCwgfjQwIGJ5dGVzCiNt YXhfZnNtX3BhZ2VzID0gMTAwMDAJCSMgbWluIDEwMDAsIGZzbSBpcyBmcmVl IHNwYWNlIG1hcCwgfjYgYnl0ZXMKI21heF9sb2Nrc19wZXJfdHJhbnNhY3Rp b24gPSA2NAkjIG1pbiAxMAojd2FsX2J1ZmZlcnMgPSA4CQkjIG1pbiA0LCB0 eXBpY2FsbHkgOEtCIGVhY2gKCiMKIwlOb24tc2hhcmVkIE1lbW9yeSBTaXpl cwojCnNvcnRfbWVtID0gODAwMCAgCQkjIG1pbiA2NCwgc2l6ZSBpbiBLQgoj dmFjdXVtX21lbSA9IDgxOTIJCSMgbWluIDEwMjQsIHNpemUgaW4gS0IKCgoj CiMJV3JpdGUtYWhlYWQgbG9nIChXQUwpCiMKY2hlY2twb2ludF9zZWdtZW50 cyA9IDkgCSMgaW4gbG9nZmlsZSBzZWdtZW50cywgbWluIDEsIDE2TUIgZWFj aAojY2hlY2twb2ludF90aW1lb3V0ID0gMzAwCSMgcmFuZ2UgMzAtMzYwMCwg aW4gc2Vjb25kcwojCiNjb21taXRfZGVsYXkgPSAwCQkjIHJhbmdlIDAtMTAw MDAwLCBpbiBtaWNyb3NlY29uZHMKI2NvbW1pdF9zaWJsaW5ncyA9IDUJCSMg cmFuZ2UgMS0xMDAwCiMKI2ZzeW5jID0gZmFsc2UKI3dhbF9zeW5jX21ldGhv ZCA9IGZzeW5jCSMgdGhlIGRlZmF1bHQgdmFyaWVzIGFjcm9zcyBwbGF0Zm9y bXM6CiMJCQkJIyBmc3luYywgZmRhdGFzeW5jLCBvcGVuX3N5bmMsIG9yIG9w ZW5fZGF0YXN5bmMKI3dhbF9kZWJ1ZyA9IDAJCQkjIHJhbmdlIDAtMTYKCgoj CiMJT3B0aW1pemVyIFBhcmFtZXRlcnMKIwplbmFibGVfc2Vxc2NhbiA9IGZh bHNlCmVuYWJsZV9pbmRleHNjYW4gPSB0cnVlCmVuYWJsZV90aWRzY2FuID0g dHJ1ZQplbmFibGVfc29ydCA9IHRydWUKZW5hYmxlX25lc3Rsb29wID0gdHJ1 ZQplbmFibGVfbWVyZ2Vqb2luID0gdHJ1ZQplbmFibGVfaGFzaGpvaW4gPSB0 cnVlCgplZmZlY3RpdmVfY2FjaGVfc2l6ZSA9IDE2MDAwCSMgdHlwaWNhbGx5 IDhLQiBlYWNoCiNyYW5kb21fcGFnZV9jb3N0ID0gNAkJIyB1bml0cyBhcmUg b25lIHNlcXVlbnRpYWwgcGFnZSBmZXRjaCBjb3N0CiNjcHVfdHVwbGVfY29z dCA9IDAuMDEJCSMgKHNhbWUpCiNjcHVfaW5kZXhfdHVwbGVfY29zdCA9IDAu MDAxCSMgKHNhbWUpCiNjcHVfb3BlcmF0b3JfY29zdCA9IDAuMDAyNQkjIChz YW1lKQoKZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldCA9IDc1MAkjIHJhbmdl IDEtMTAwMAoKIwojCUdFUU8gT3B0aW1pemVyIFBhcmFtZXRlcnMKIwojZ2Vx byA9IHRydWUKI2dlcW9fc2VsZWN0aW9uX2JpYXMgPSAyLjAJIyByYW5nZSAx LjUtMi4wCiNnZXFvX3RocmVzaG9sZCA9IDExCiNnZXFvX3Bvb2xfc2l6ZSA9 IDAJCSMgZGVmYXVsdCBiYXNlZCBvbiB0YWJsZXMgaW4gc3RhdGVtZW50LCAK CQkJCSMgcmFuZ2UgMTI4LTEwMjQKI2dlcW9fZWZmb3J0ID0gMQojZ2Vxb19n ZW5lcmF0aW9ucyA9IDAKI2dlcW9fcmFuZG9tX3NlZWQgPSAtMQkJIyBhdXRv LWNvbXB1dGUgc2VlZAoKCiMKIwlNZXNzYWdlIGRpc3BsYXkKIwojc2VydmVy X21pbl9tZXNzYWdlcyA9IG5vdGljZQkjIFZhbHVlcywgaW4gb3JkZXIgb2Yg ZGVjcmVhc2luZyBkZXRhaWw6CgkJCQkjICAgZGVidWc1LCBkZWJ1ZzQsIGRl YnVnMywgZGVidWcyLCBkZWJ1ZzEsCgkJCQkjICAgaW5mbywgbm90aWNlLCB3 YXJuaW5nLCBlcnJvciwgbG9nLCBmYXRhbCwKCQkJCSMgICBwYW5pYwojY2xp ZW50X21pbl9tZXNzYWdlcyA9IG5vdGljZQkjIFZhbHVlcywgaW4gb3JkZXIg b2YgZGVjcmVhc2luZyBkZXRhaWw6CgkJCQkjICAgZGVidWc1LCBkZWJ1ZzQs IGRlYnVnMywgZGVidWcyLCBkZWJ1ZzEsCgkJCQkjICAgbG9nLCBpbmZvLCBu b3RpY2UsIHdhcm5pbmcsIGVycm9yCiNzaWxlbnRfbW9kZSA9IGZhbHNlCgoj bG9nX2Nvbm5lY3Rpb25zID0gZmFsc2UKI2xvZ19waWQgPSBmYWxzZQojbG9n X3N0YXRlbWVudCA9IGZhbHNlCiNsb2dfZHVyYXRpb24gPSBmYWxzZQpsb2df dGltZXN0YW1wID0gdHJ1ZQoKI2xvZ19taW5fZXJyb3Jfc3RhdGVtZW50ID0g ZXJyb3IgIyBWYWx1ZXMgaW4gb3JkZXIgb2YgaW5jcmVhc2luZyBzZXZlcml0 eToKCQkJCSAjICAgZGVidWc1LCBkZWJ1ZzQsIGRlYnVnMywgZGVidWcyLCBk ZWJ1ZzEsCgkJCQkgIyAgIGluZm8sIG5vdGljZSwgd2FybmluZywgZXJyb3Is IHBhbmljKG9mZikKCiNkZWJ1Z19wcmludF9wYXJzZSA9IGZhbHNlCiNkZWJ1 Z19wcmludF9yZXdyaXR0ZW4gPSBmYWxzZQojZGVidWdfcHJpbnRfcGxhbiA9 IGZhbHNlCiNkZWJ1Z19wcmV0dHlfcHJpbnQgPSBmYWxzZQoKI2V4cGxhaW5f cHJldHR5X3ByaW50ID0gdHJ1ZQoKIyByZXF1aXJlcyBVU0VfQVNTRVJUX0NI RUNLSU5HCiNkZWJ1Z19hc3NlcnRpb25zID0gdHJ1ZQoKCiMKIwlTeXNsb2cK Iwojc3lzbG9nID0gMAkJCSMgcmFuZ2UgMC0yCiNzeXNsb2dfZmFjaWxpdHkg PSAnTE9DQUwwJwojc3lzbG9nX2lkZW50ID0gJ3Bvc3RncmVzJwoKCiMKIwlT dGF0aXN0aWNzCiMKI3Nob3dfcGFyc2VyX3N0YXRzID0gZmFsc2UKI3Nob3df cGxhbm5lcl9zdGF0cyA9IGZhbHNlCiNzaG93X2V4ZWN1dG9yX3N0YXRzID0g ZmFsc2UKI3Nob3dfc3RhdGVtZW50X3N0YXRzID0gZmFsc2UKCiMgcmVxdWly ZXMgQlRSRUVfQlVJTERfU1RBVFMKI3Nob3dfYnRyZWVfYnVpbGRfc3RhdHMg PSBmYWxzZQoKCiMKIwlBY2Nlc3Mgc3RhdGlzdGljcyBjb2xsZWN0aW9uCiMK I3N0YXRzX3N0YXJ0X2NvbGxlY3RvciA9IHRydWUKI3N0YXRzX3Jlc2V0X29u X3NlcnZlcl9zdGFydCA9IHRydWUKI3N0YXRzX2NvbW1hbmRfc3RyaW5nID0g ZmFsc2UKI3N0YXRzX3Jvd19sZXZlbCA9IGZhbHNlCiNzdGF0c19ibG9ja19s ZXZlbCA9IGZhbHNlCgoKIwojCUxvY2sgVHJhY2luZwojCiN0cmFjZV9ub3Rp ZnkgPSBmYWxzZQoKIyByZXF1aXJlcyBMT0NLX0RFQlVHCiN0cmFjZV9sb2Nr cyA9IGZhbHNlCiN0cmFjZV91c2VybG9ja3MgPSBmYWxzZQojdHJhY2VfbHds b2NrcyA9IGZhbHNlCiNkZWJ1Z19kZWFkbG9ja3MgPSBmYWxzZQojdHJhY2Vf bG9ja19vaWRtaW4gPSAxNjM4NAojdHJhY2VfbG9ja190YWJsZSA9IDAKCgoj CiMJTWlzYwojCiNhdXRvY29tbWl0ID0gdHJ1ZQojZHluYW1pY19saWJyYXJ5 X3BhdGggPSAnJGxpYmRpcicKc2VhcmNoX3BhdGggPSAndmVuZGFzJwojZGF0 ZXN0eWxlID0gJ2lzbywgdXMnCiN0aW1lem9uZSA9IHVua25vd24JCSMgYWN0 dWFsbHksIGRlZmF1bHRzIHRvIFRaIGVudmlyb25tZW50IHNldHRpbmcKI2F1 c3RyYWxpYW5fdGltZXpvbmVzID0gZmFsc2UKI2NsaWVudF9lbmNvZGluZyA9 IHNxbF9hc2NpaQkjIGFjdHVhbGx5LCBkZWZhdWx0cyB0byBkYXRhYmFzZSBl bmNvZGluZwojYXV0aGVudGljYXRpb25fdGltZW91dCA9IDYwCSMgMS02MDAs IGluIHNlY29uZHMKI2RlYWRsb2NrX3RpbWVvdXQgPSAxMDAwCSMgaW4gbWls bGlzZWNvbmRzCiNkZWZhdWx0X3RyYW5zYWN0aW9uX2lzb2xhdGlvbiA9ICdy ZWFkIGNvbW1pdHRlZCcKI21heF9leHByX2RlcHRoID0gMTAwMDAJCSMgbWlu IDEwCiNtYXhfZmlsZXNfcGVyX3Byb2Nlc3MgPSAxMDAwCSMgbWluIDI1CiNw YXNzd29yZF9lbmNyeXB0aW9uID0gdHJ1ZQojc3FsX2luaGVyaXRhbmNlID0g dHJ1ZQojdHJhbnNmb3JtX251bGxfZXF1YWxzID0gZmFsc2UKI3N0YXRlbWVu dF90aW1lb3V0ID0gMAkJIyAwIGlzIGRpc2FibGVkLCBpbiBtaWxsaXNlY29u ZHMKI2RiX3VzZXJfbmFtZXNwYWNlID0gZmFsc2UKIAoKCiMKIwlMb2NhbGUg c2V0dGluZ3MKIwojIChpbml0aWFsaXplZCBieSBpbml0ZGIgLS0gbWF5IGJl IGNoYW5nZWQpCkxDX01FU1NBR0VTID0gJ2VuX1VTLlVURi04JwpMQ19NT05F VEFSWSA9ICdlbl9VUy5VVEYtOCcKTENfTlVNRVJJQyA9ICdlbl9VUy5VVEYt OCcKTENfVElNRSA9ICdlbl9VUy5VVEYtOCcK ---MOQ1062621852172764d69df60a690f4a054550b71562--