PostgreSQL Benchmarks

I agree tottaly with you, but I need some data to show to my clients.
Today I use PostgreSQL in a couple of projects and it always fulfilled
my needs.
I already analysed the situation and I think PostgreSQL is perfect for
this project,
but the client does not trust in an open source solution.

Maybe some benchmarks comparing pg to comercial databases would help to
convince him.
I found a comparison chart in the MySQL site, but if anynone knows about
something else.

TIA

Probably at Microsoft site but I wooldn't recommend you to trust them.
I think this is not a relevant information unless you want to show your
boss
that postgres is a spark light.
You should analyse your needs and see if postgres or any other rdbms is
what
you need regardless of being the fastest/slowest on the market.
I use it for many applications and don't care if it is faster or slower
than
any other rdms. I am probably far below its possibilities on the hardware
it
is given, but it does what I need it to do and that's more than enough for
me.

Hope this helps.
Fathi Ben Nasr

Diogo Biazus a �crit :

Does anybody knows where I can find good PostgreSQL benchmarks comparing
it to Oracle and/or MS SQL Server?

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automa��o
http://www.ikono.com.br

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

(See attached file: smime.p7s)

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automa��o
http://www.ikono.com.br

Ask him if he ever accessed a .org web site. That name lookup will be
powered by PostgreSQL soon. They just won the contract yesterday.

---------------------------------------------------------------------------

Diogo Biazus wrote:

I agree tottaly with you, but I need some data to show to my clients.
Today I use PostgreSQL in a couple of projects and it always fulfilled
my needs.
I already analysed the situation and I think PostgreSQL is perfect for
this project,
but the client does not trust in an open source solution.

Maybe some benchmarks comparing pg to comercial databases would help to
convince him.
I found a comparison chart in the MySQL site, but if anynone knows about
something else.

TIA

Probably at Microsoft site but I wooldn't recommend you to trust them.
I think this is not a relevant information unless you want to show your
boss
that postgres is a spark light.
You should analyse your needs and see if postgres or any other rdbms is
what
you need regardless of being the fastest/slowest on the market.
I use it for many applications and don't care if it is faster or slower
than
any other rdms. I am probably far below its possibilities on the hardware
it
is given, but it does what I need it to do and that's more than enough for
me.

Hope this helps.
Fathi Ben Nasr

Diogo Biazus a ?crit :

Does anybody knows where I can find good PostgreSQL benchmarks comparing
it to Oracle and/or MS SQL Server?

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automa??o
http://www.ikono.com.br

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

(See attached file: smime.p7s)

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automa??o
http://www.ikono.com.br

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Nearly one year ago, a company making odbc drivers made a comparison of
postgresql compared to mysql, a free rdbms from borland and two dbms
tenors
one version 8.0.4 without naming oracle and the other version 7.0 without
naming sqlserver du to some EULA that forbids using or naming this two
later
products in benchmarks without an explicit agreement from oracle or
microsoft.
This benchmark not only showed that postgres is the fastest but that it is
also
the one that scales better.
I found the link on the postgres site. Have to look if it is always there.

Fathi B.N.

Diogo Biazus a écrit :

I agree tottaly with you, but I need some data to show to my clients.
Today I use PostgreSQL in a couple of projects and it always fulfilled
my needs.
I already analysed the situation and I think PostgreSQL is perfect for
this project,
but the client does not trust in an open source solution.

Maybe some benchmarks comparing pg to comercial databases would help to
convince him.
I found a comparison chart in the MySQL site, but if anynone knows about
something else.

TIA

Probably at Microsoft site but I wooldn't recommend you to trust them.
I think this is not a relevant information unless you want to show your
boss
that postgres is a spark light.
You should analyse your needs and see if postgres or any other rdbms is
what
you need regardless of being the fastest/slowest on the market.
I use it for many applications and don't care if it is faster or slower
than
any other rdms. I am probably far below its possibilities on the

hardware

it
is given, but it does what I need it to do and that's more than enough

for

me.

Hope this helps.
Fathi Ben Nasr

Diogo Biazus a écrit :

Does anybody knows where I can find good PostgreSQL benchmarks

comparing

it to Oracle and/or MS SQL Server?

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br

---------------------------(end of broadcast)

---------------------------

TIP 4: Don't 'kill -9' the postmaster

(See attached file: smime.p7s)

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

(See attached file: smime.p7s)

On Tue, Oct 15, 2002 at 06:09:56PM -0400, Bruce Momjian wrote:

Ask him if he ever accessed a .org web site. That name lookup will be
powered by PostgreSQL soon. They just won the contract yesterday.

And .info is powered by PostgreSQL today. Our remarks on the subject
are available for public consumptions here:

http://www.icann.org/tlds/org/questions-to-applicants-13.htm#Response13TheInternetSocietyISOC

(sorry about the long line). No, I don't have any compare-to-Oracle
benchmarks to share, alas. But PostgreSQL meets our needs. For a
quick demonstration of how fast PostgreSQL can be, you can execute
this:

$ whois -h whois.afilias.net afilias.info

I should tell you that it's sort of a cheat: the reason for the speed
is partly the database design. But Postgres is nice and fast in our
experience, provided you configure and program correctly. Sounds
like everything else, to me.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

So the database is actually feeding the dns requests?

---------------------------------------------------------------------------

Andrew Sullivan wrote:

On Tue, Oct 15, 2002 at 06:09:56PM -0400, Bruce Momjian wrote:

Ask him if he ever accessed a .org web site. That name lookup will be
powered by PostgreSQL soon. They just won the contract yesterday.

And .info is powered by PostgreSQL today. Our remarks on the subject
are available for public consumptions here:

http://www.icann.org/tlds/org/questions-to-applicants-13.htm#Response13TheInternetSocietyISOC

(sorry about the long line). No, I don't have any compare-to-Oracle
benchmarks to share, alas. But PostgreSQL meets our needs. For a
quick demonstration of how fast PostgreSQL can be, you can execute
this:

$ whois -h whois.afilias.net afilias.info

I should tell you that it's sort of a cheat: the reason for the speed
is partly the database design. But Postgres is nice and fast in our
experience, provided you configure and program correctly. Sounds
like everything else, to me.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
+1 416 646 3304 x110

---------------------------(end of broadcast)---------------------------
TIP 3: 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

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Fri, Oct 18, 2002 at 03:04:00PM -0400, Bruce Momjian wrote:

So the database is actually feeding the dns requests?

No, DNS is outsourced to (currently) UltraDNS. We have an API to
them, and inject our DNS information to their DNS system.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110