pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed[IMPORTANT] - My application performance
4+ messages / 4 participants
[nested] [flat]
* [IMPORTANT] - My application performance
@ 2005-07-26 19:35 Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
2005-07-26 20:05 ` Re: [IMPORTANT] - My application performance Jim C. Nasby <decibel@decibel.org>
2005-07-27 02:02 ` Re: [IMPORTANT] - My application performance Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-07-27 07:28 ` Re: [IMPORTANT] - My application performance Dawid Kuroczko <qnex42@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Roberto Germano Vieweg Neto @ 2005-07-26 19:35 UTC (permalink / raw)
To: pgsql-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 ?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [IMPORTANT] - My application performance
2005-07-26 19:35 [IMPORTANT] - My application performance Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
@ 2005-07-26 20:05 ` Jim C. Nasby <decibel@decibel.org>
2 siblings, 0 replies; 4+ messages in thread
From: Jim C. Nasby @ 2005-07-26 20:05 UTC (permalink / raw)
To: Roberto Germano Vieweg Neto <beto.neto@pop.com.br>; +Cc: pgsql-performance
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?"
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [IMPORTANT] - My application performance
2005-07-26 19:35 [IMPORTANT] - My application performance Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
@ 2005-07-27 02:02 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2 siblings, 0 replies; 4+ messages in thread
From: Christopher Kings-Lynne @ 2005-07-27 02:02 UTC (permalink / raw)
To: Roberto Germano Vieweg Neto <beto.neto@pop.com.br>; +Cc: pgsql-performance
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 think you can probably expect around 10341.426% improvement.
ps. Yes, I am joking just in case...
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [IMPORTANT] - My application performance
2005-07-26 19:35 [IMPORTANT] - My application performance Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
@ 2005-07-27 07:28 ` Dawid Kuroczko <qnex42@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Dawid Kuroczko @ 2005-07-27 07:28 UTC (permalink / raw)
To: Roberto Germano Vieweg Neto <beto.neto@pop.com.br>; +Cc: pgsql-performance
On 7/26/05, Roberto Germano Vieweg Neto <beto.neto@pop.com.br> wrote:
> My application is using Firebird 1.5.2
>
> 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 ?
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 ANALYZEs
and ask if there's something you can do to speed it up.
Regards,
Dawid
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-07-27 07:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-26 19:35 [IMPORTANT] - My application performance Roberto Germano Vieweg Neto <beto.neto@pop.com.br>
2005-07-26 20:05 ` Jim C. Nasby <decibel@decibel.org>
2005-07-27 02:02 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-07-27 07:28 ` Dawid Kuroczko <qnex42@gmail.com>
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