X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0B4303A3D02 for ; Sat, 6 Nov 2004 19:52:24 +0000 (GMT) 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 45297-05 for ; Sat, 6 Nov 2004 19:52:16 +0000 (GMT) Received: from web52706.mail.yahoo.com (web52706.mail.yahoo.com [206.190.39.157]) by svr1.postgresql.org (Postfix) with SMTP id 3D3593A3D6C for ; Sat, 6 Nov 2004 19:52:16 +0000 (GMT) Message-ID: <20041106195215.91282.qmail@web52706.mail.yahoo.com> Received: from [168.243.73.4] by web52706.mail.yahoo.com via HTTP; Sat, 06 Nov 2004 11:52:15 PST Date: Sat, 6 Nov 2004 11:52:15 -0800 (PST) From: Carlos Lopez Subject: poor performance in migrated database To: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/47 X-Sequence-Number: 15432 I have migrated a database from MS SQL to a postgresSQL database, but when running it, the results are very slow (and unusable) which is the only reason we don't entirely move to postgresSQL. The problem is that there are many nested views which normally join tables by using two fields, one character and other integer. The biggest table has about 300k records (isn't it too little for having performance problems?) What could be the poor performance reason? the server is a dual itanium (intel 64bits) processor with 6Gb of RAM and a 36Gb Raid 5 scsi hdds of 15k rpm. If someone has the time and wants to check the structure, I have a copy of everything at http://www.micredito.com.sv/.carlos/materiales.sql.bz2 it is a pgsqldump made with postgres 7.4 Thanks in advance for your help. Carlos Lopez Linares. ===== ___ Ing. Carlos López Linares IT Consultant Quieres aprender linux? visita http://www.aprende-linux.com.sv __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com