From: Jim C. Nasby <decibel@decibel.org>
To: Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: [IMPORTANT] - My application performance
Date: Tue, 26 Jul 2005 15:05:00 -0500
Message-ID: <20050726200500.GY29346@decibel.org> (raw)
In-Reply-To: <38776.200.101.246.47.1122406519.squirrel@popmail5.pop.com.br>
References: <38776.200.101.246.47.1122406519.squirrel@popmail5.pop.com.br>
The number of objects in your system has virtually nothing to do with
performance (at least on any decent database...)
What is your application doing? What's the bottleneck right now?
On Tue, Jul 26, 2005 at 04:35:19PM -0300, Roberto Germano Vieweg Neto wrote:
> 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
>
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: decibel@decibel.org, beto.neto@pop.com.br
Subject: Re: [IMPORTANT] - My application performance
In-Reply-To: <20050726200500.GY29346@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox