Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E9B83479F13 for ; Thu, 23 Jan 2003 17:26:00 -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 74685477146 for ; Thu, 23 Jan 2003 15:31:40 -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 h0NKV3l21659 for ; Thu, 23 Jan 2003 18:31:03 -0200 Received: from 200.225.202.15 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Thu, 23 Jan 2003 18:31:03 -0200 (BRST) Message-ID: <10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br> Date: Thu, 23 Jan 2003 18:31:03 -0200 (BRST) Subject: Re: Same query, same performance From: "alexandre :: aldeia digital" To: In-Reply-To: References: <10635.200.225.202.15.1043288804.squirrel@webmail.ad2.com.br> 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/273 X-Sequence-Number: 920 Josh, > Alexandre, > >> I have a system with 7 Million of records in 600 tables. >> My actual production machine is: P4 1.6G, 3 IDE 7200, 1GB PC133 >> My new machine production is: Dual Xeon 2.0G HT, 1GB DDR266 ECC >> 3 SCSI with HW Raid 5 > > Well, first of all, those two systems are almost equivalent as far as > Postgres is concerned for simple queries. The extra processor power > will only help you with very complex queries. 3-disk RAID 5 is no > faster ... and sometimes slower ... than IDE for database purposes. > The only real boost to the Xeon is the faster RAM ... which may not > help you if your drive array is the bottleneck. Today, I will add more one HD and I will make an RAID 10 ... In next week i will report my tests to the list... > >> >> The postgresql.conf is the SAME in both systems and I test >> with no other connections, only my local test. >> >> shared_buffers = 80000 >> effective_cache_size = 60000 >> random_page_cost = 2.5 >> cpu_tuple_cost = 0.001 >> cpu_index_tuple_cost = 0.0001 >> cpu_operator_cost = 0.00025 > > Not that it affects the query below, but what about SORT_MEM? Sort_mem = 32000 > Actually, from your stats, Postgres is doing a pretty good job. 1.18 > seconds to return 15 rows from a 7 million row table searching on not > Indexed columns? I don't think you have anything to complain about. The table have 300000 tuples, the entire database have 7 million. Tomazs answer the question: a missing index on fn06t ... But the query time difference of the systems continue. I will change the discs and tell to list after... Thank´s Josh, Alexandre