X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57FA652BD5 for ; Tue, 26 Jul 2005 18:03:27 -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 84860-01 for ; Tue, 26 Jul 2005 21:03:18 +0000 (GMT) Received: from dfbsa63.conab.gov.br (dfbsa63.conab.gov.br [200.140.131.205]) by svr1.postgresql.org (Postfix) with ESMTP id 0B22252CB3 for ; Tue, 26 Jul 2005 18:03:16 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by dfbsa63.conab.gov.br (Postfix) with ESMTP id 733C24C0DD for ; Tue, 26 Jul 2005 18:00:53 -0300 (BRT) Received: from dfbsa63.conab.gov.br ([127.0.0.1]) by localhost (dfbsa63 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04878-40 for ; Tue, 26 Jul 2005 18:00:52 -0300 (BRT) Received: from gesin557 (unknown [10.1.2.201]) by dfbsa63.conab.gov.br (Postfix) with ESMTP id AB1294C0C7 for ; Tue, 26 Jul 2005 18:00:52 -0300 (BRT) From: "Alvaro Neto" To: Subject: RES: [IMPORTANT] - My application performance Date: Tue, 26 Jul 2005 18:00:52 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <38776.200.101.246.47.1122406519.squirrel@popmail5.pop.com.br> Thread-Index: AcWSGRQpcSi61uyYSl+z6FlkKRCY0QAC/vrg Message-Id: <20050726210052.AB1294C0C7@dfbsa63.conab.gov.br> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at conab.gov.br X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.18 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/408 X-Sequence-Number: 13649 What's the your platform? Windows or Linux? What's the data volume (up million records)? -----Mensagem original----- De: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] Em nome de Roberto = Germano Vieweg Neto Enviada em: ter=E7a-feira, 26 de julho de 2005 16:35 Para: pgsql-performance@postgresql.org Assunto: [PERFORM] [IMPORTANT] - My application performance My application is using Firebird 1.5.2 I have at my database: - 150 Doamins - 318 tables - 141 Views - 365 Procedures - 407 Triggers - 75 generators - 161 Exceptions - 183 UDFs - 1077 Indexes My question is: Postgre SQL will be more faster than Firebird? How much (in percent)? I need about 20% to 50% more performance at my application. Can I get this migratin to postgresql ? ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match