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 EA13F52EBB for ; Wed, 27 Jul 2005 04:28:09 -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 64629-07 for ; Wed, 27 Jul 2005 07:28:00 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by svr1.postgresql.org (Postfix) with ESMTP id DE94152EDD for ; Wed, 27 Jul 2005 04:27:58 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so104624nzo for ; Wed, 27 Jul 2005 00:28:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QSCGRSyaqvi0nKmeuQuxyHNuoozhJmEJSxAmlX9/mOJ0j1G3SBRvaDWTQLxqSvFvofKngmLyJqqGg4Gd3WVdDTG6l2zM6puDwLD7CWc1tUVJbWtKTNHBYayHsHoRke7U7iZ1QbWnjyxxqG1FOfm/YONpvVI5XFODcIJ3Y/sVxzo= Received: by 10.37.12.49 with SMTP id p49mr608946nzi; Wed, 27 Jul 2005 00:28:00 -0700 (PDT) Received: by 10.36.22.20 with HTTP; Wed, 27 Jul 2005 00:28:00 -0700 (PDT) Message-ID: <758d5e7f050727002844a1ad3c@mail.gmail.com> Date: Wed, 27 Jul 2005 09:28:00 +0200 From: Dawid Kuroczko Reply-To: Dawid Kuroczko To: Roberto Germano Vieweg Neto Subject: Re: [IMPORTANT] - My application performance Cc: pgsql-performance@postgresql.org In-Reply-To: <38776.200.101.246.47.1122406519.squirrel@popmail5.pop.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <38776.200.101.246.47.1122406519.squirrel@popmail5.pop.com.br> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.617 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/413 X-Sequence-Number: 13654 On 7/26/05, Roberto Germano Vieweg Neto wrote: > My application is using Firebird 1.5.2 >=20 > My question is: >=20 > Postgre SQL will be more faster than Firebird? How much (in percent)? >=20 > I need about 20% to 50% more performance at my application. > Can I get this migratin to postgresql ? The answer is: maybe. There's nothing which stops PostgreSQL from being faster, and likewise there is nothing that stops it from being slower. YMMV. Your route should be: * migrate most speed-demanding part to PostgreSQL * benchmark it, trying to emulate real-world load. * if it is slower than Firebird, post it here, together with EXPLAIN ANALY= ZEs and ask if there's something you can do to speed it up. Regards, Dawid