Statistics

Started by Ezequias Rodrigues da Rochaabout 19 years ago5 messagesgeneral
Jump to latest
#1Ezequias Rodrigues da Rocha
ezequias.rocha@gmail.com

Hi list,

Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of do not
put Oracle in our organization.

We are quite well with postgresql and I have no plans to change my
plataform.

Regards

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

#2Joe
dev@freedomcircle.net
In reply to: Ezequias Rodrigues da Rocha (#1)
Re: [SQL] Statistics

On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:

Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of
do not put Oracle in our organization.

We are quite well with postgresql and I have no plans to change my
plataform.

Allow me to quote from my response to your previous message back in
November:

On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote:

Does anybody have numbers of PostgreSQL in action ?

Numbers like the biggest insert in mileseconds, the larger database

etc ?

First, you may want to post this in the GENERAL or in the PERFORMANCE
lists since this isn't really about SQL.

Second, you may want to look at the case studies page:
http://www.postgresql.org/about/casestudies/.

Third, the companies like EnterpriseDB and Pervasive may have some of
what you're looking for since they have to measure themselves against
the competition.

And remember to take any numbers with a large grain of salt, YMMV, etc.

Joe

#3Ezequias Rodrigues da Rocha
ezequias.rocha@gmail.com
In reply to: Joe (#2)

On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of

do not put Oracle in our organization.

We are quite well with postgresql and I have no plans to change my
plataform.

Ezequias

#4Hiltibidal, Robert
Robert.Hiltibidal@argushealth.com
In reply to: Joe (#2)
Re: [SQL] Statistics

Joe is quite right about comparing stats. Unless things are equal across
the board (database, tables, data, hardware, software) results will
always differ.

Another consideration and this may be painful, is consider what Oracle
support may be able to offer. Executives do not want to hear the core of
their operations went down at 3 am and are still down pending answer to
e-mail based support questions. There is benefit when IBM/Oracle can
have someone onsite in off hours if that level of support is needed.

DBA's/sysadmins/developers are always looking for the best way to
accomplish a goal depending on hardware/software/skillset availability.

Bean counters are always looking for the best way to accomplish a goal
balancing operational costs with profitability. Open source isn't always
the most profitable solution.

Good profitability is usually a balance between open source and
commercial.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Joe
Sent: Friday, March 09, 2007 11:36 AM
To: Ezequias Rodrigues da Rocha
Cc: PostgreSQL; Pgadmin-Support
Subject: Re: [SQL] Statistics

On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:

Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of
do not put Oracle in our organization.

We are quite well with postgresql and I have no plans to change my
plataform.

Allow me to quote from my response to your previous message back in
November:

On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote:

Does anybody have numbers of PostgreSQL in action ?

Numbers like the biggest insert in mileseconds, the larger database

etc ?

First, you may want to post this in the GENERAL or in the PERFORMANCE
lists since this isn't really about SQL.

Second, you may want to look at the case studies page:
http://www.postgresql.org/about/casestudies/.

Third, the companies like EnterpriseDB and Pervasive may have some of
what you're looking for since they have to measure themselves against
the competition.

And remember to take any numbers with a large grain of salt, YMMV, etc.

Joe

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

PRIVILEGED AND CONFIDENTIAL
This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.

#5Jeff Davis
pgsql@j-davis.com
In reply to: Ezequias Rodrigues da Rocha (#3)
Re: Statistics

On Fri, 2007-03-09 at 14:40 -0300, Ezequias Rodrigues da Rocha wrote:

On Fri, 2007-03-09 at 14:22 -0300, Ezequias Rodrigues da Rocha wrote:
Does someone have statistcs from PostgreSQL ? Numbers from the list,
performance statistics. I must argue with another person the idea of

do not put Oracle in our organization.

We are quite well with postgresql and I have no plans to change my
plataform.

If PostgreSQL is working well, then continue using it.

If you (or another person) are concerned about scalability for the
future, call one of the commercial PostgreSQL support companies listed
here:

http://www.postgresql.org/support/professional_support

They can guide you through the process to make sure that your
implementation scales according to your needs.

Or, just ask more specific questions on this list, and people will be
glad to help.

Regards,
Jeff Davis