Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A53C7476768 for ; Thu, 23 Jan 2003 16:26:54 -0500 (EST) Received: from spirit.aldeiadigital.com.br (iplus-fac-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by postgresql.org (Postfix) with ESMTP id 1C86F476860 for ; Thu, 23 Jan 2003 14:50:27 -0500 (EST) Received: from aldeiadigital.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id h0NJnbl21150 for ; Thu, 23 Jan 2003 17:49:37 -0200 Received: from 200.225.202.15 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Thu, 23 Jan 2003 17:49:37 -0200 (BRST) Message-ID: <10840.200.225.202.15.1043351377.squirrel@webmail.ad2.com.br> Date: Thu, 23 Jan 2003 17:49:37 -0200 (BRST) Subject: Re: Same query, same performance From: "alexandre :: aldeia digital" To: In-Reply-To: <3E2FA5B9.1030105@klaster.net> References: <10635.200.225.202.15.1043288804.squirrel@webmail.ad2.com.br> <3E2FA5B9.1030105@klaster.net> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/272 X-Sequence-Number: 919 Tomasz, >>1) ! 1.185424 elapsed 1.090000 user 0.100000 system sec >>2) ! 1.184415 elapsed 1.070000 user 0.120000 system sec >>3) ! 1.185209 elapsed 1.100000 user 0.080000 system sec >> >>If the disks is not read directly, the system must find >>the rows in RAM. If it find in RAM, why so diffrents machines >>have the times of execution and why the times does not down ??? > > Here is your problem: > -> Seq Scan on fn06t t1 (cost=0.00..25808.30 rows=15 width=95) > Filter: ((fn06emp07 = 1::smallint) AND (fn06tiptit = > 'R'::bpchar) AND (fn06titban = '002021001525 > '::bpchar)) Really! I do not attemp that fn06t does not have an index with fn06titban ... :) Now, tehe time of the querys are < 0.02 sec on P4 and <0.05 on Xeon. Very Thank´s Alexandre,