Thread: PostgreSQL Benchmarks
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
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
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
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)
Attachment
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