Обсуждение: [Fwd: PostGreSQL information]
Hi everyone, Does someone feel like saying Hi to Brad here, and assisting him with the info he needs? I'm worn out and about to go home. :-/ Regards and best wishes, Justin Clift -------- Original Message -------- Subject: PostGreSQL information Date: Mon, 16 Jun 2003 13:12:41 -0600 From: Bradley G. Dick <brad@petrodat.com> To: justin@postgresql.org I just tried emailing you through your web form, but got an error message. These are the details I am interested in. Can you please provide me information on licensing and maintenance costs, as well as details on platforms PostgreSQL is available on? For example is it available on Tru64 Unix and can it take advantage of the Large Memory Model, of a 64 bit operating system? Also, what are the database connectivity options, ODBC, JDBC etc. How does it's performance compare to Oracle and DB2 etc. Regards, Brad --
On Thursday 19 Jun 2003 12:23 pm, Justin Clift wrote: > Hi everyone, > > Does someone feel like saying Hi to Brad here, and assisting him with > the info he needs? I'm worn out and about to go home. :-/ I'll grab this, although I don't know anything about Tru64 Unix - anyone out there got experience? > Can you please provide me information on licensing and maintenance > costs, as well as details on platforms PostgreSQL is available on? For > example is it available on Tru64 Unix and can it take advantage of the > Large Memory Model, of a 64 bit operating system? Also, what are the > database connectivity options, ODBC, JDBC etc. How does it's > performance compare to Oracle and DB2 etc. > > Regards, > Brad -- Richard Huxton
Hello Bradley, I'm a subscriber to the PostgreSQL General mailing list and your query was passed here. What with time-zones etc. you may get several responses to your query, I hope mine is useful. I've taken the liberty of CCing this reply back to the list, in case anyone else has useful comments. Bear in mind I am just a user of PG, although one with some experience. 1. Licencing PostgreSQL is open-source and there are no licencing costs. Under the BSD licence you are given a great deal of freedom to install, modify and distribute the system. General info on PG: http://advocacy.postgresql.org/ Details on open-source licencing: http://www.opensource.org/licenses/ 2. Maintenance The PostgreSQL mailing lists are (in my opinion) excellent, and there are a number covering different topics. You can find more at: http://www.postgresql.org/lists.html http://archives.postgresql.org/ There is also paid support available from a number of companies and independent consultants: http://techdocs.postgresql.org/companies.php 3. Platform - Tru64 Unix It appears your platform is supported: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=supported-platforms.html I'm afraid I can't comment in detail on the 64-bit usage, you might have success searching the mailing list archives at the link in section 2. 5. Connectivity PostgreSQL supports both ODBC and JDBC. http://gborg.postgresql.org/project/psqlodbc/projdisplay.php http://jdbc.postgresql.org/ I use the ODBC driver regularly to access PG from Windows machines (an Access or VB front-end). 6. Performance Benchmarking is a tricky subject. Not only does the choice of test make a big difference, most commercial databases don't allow comparative benchmarks to be published. My very unscientific feeling is that PostgreSQL is comparable to Oracle in most cases. Where Oracle does win is that it offers more "special case" tunings for specific application types and situations. Where PostgreSQL wins is that you can spend some of the money saved on Oracle licences on more hardware, which can make a huge difference, depending on the size of your database. Probably the best I can recommend is that you download and install PostgreSQL and run some tests against it - nothing can beat real-world testing. If you find some problems, there is a "performance" mailing list where you can find help. If you have an existing Oracle database you are trying to convert from you may find some of the articles below useful: http://techdocs.postgresql.org/#convertfrom I hope this addresses your questions. If you want to know any more, I can recommend the pgsql-general mailing list, or feel free to contact me directly. -- Richard Huxton
Hi Brad, Here's some answers to your questions and some references. Firstly, a very good thumbnail page of information is here: http://www.postgresql.org/users-lounge/features.html > Can you please provide me information on licensing and maintenance > costs, as well as details on platforms PostgreSQL is available on? PostgreSQL is an open source product, so you can download and use the code for free, without restriction. Support packages are available from a number of different companies, with different pricing options. http://techdocs.postgresql.org/companies.php > For example is it available on Tru64 Unix and can it take advantage of the > Large Memory Model, of a 64 bit operating system? It is available for Tru64. It can take advantage of 64 bit operating systems. I don't know about memory, my inclination would be to say to would take advantage of whatever shared memory you were willing to expose for it, but will have to get verification from elsewhere. > Also, what are the > database connectivity options, ODBC, JDBC etc. ODBC, JDBC, of course. Also bindings for C, C++, Perl, Python, TCL, PHP, and almost every other language under the sun. There is a .Net provider too. > How does it's > performance compare to Oracle and DB2 etc. My personal experience is that it blows Oracle out of the water speedwise, but my personal experience tends to be with transactionally light applications. Some benchmarks published a couple years ago showed PgSQL at that time was comparable to the "leading commercial database" under some standard transactional testing scenario (a TPC-C style test), and PgSQL has improved alot since then. Performance benchmarks are hard, because they are expensive to do, and licencing from the proprietary vendors generally prevents you from publishing the results without their say so. So one could spend alot of time and money creating an unpublishable benchmark. :/ If performance is a deal breaker, the best thing is to put all the candidates on the bench yourself and stress them the way you think they are going to be operationally stressed. Paul -- __ / | Paul Ramsey | Refractions Research | Email: pramsey@refractions.net | Phone: (250) 885-0632 \_
I built and ran Pg on Tru64 about a year ago. I recall having to edit pg_ctl a bit... Does that count as experience? regards Mark Richard Huxton wrote: >On Thursday 19 Jun 2003 12:23 pm, Justin Clift wrote: > > >>Hi everyone, >> >>Does someone feel like saying Hi to Brad here, and assisting him with >>the info he needs? I'm worn out and about to go home. :-/ >> >> > >I'll grab this, although I don't know anything about Tru64 Unix - anyone out >there got experience? > > >>Can you please provide me information on licensing and maintenance >>costs, as well as details on platforms PostgreSQL is available on? For >>example is it available on Tru64 Unix and can it take advantage of the >>Large Memory Model, of a 64 bit operating system? Also, what are the >>database connectivity options, ODBC, JDBC etc. How does it's >>performance compare to Oracle and DB2 etc. >> >>Regards, >>Brad >> >> > > >