I think it would make more sense to explain the difference between PostgreSQL and other databases, like MySQL and Oracle, than between current PostgreSQL and its archaic versions.
Or give the short list of unique features at least: tell about ACID, MVCC, WAL, what makes it work as a high-end database server as well as a backend of web-application servers.
User supporting and Documentation
I've been using PostgreSQL for over 6 month, and I've found it great according to it's knownladge. But every time when I want to do some non-basic things(findig information on built-in functions etc) I have to search 1) the included documentation 2) the web site 3) google.com for information about the topic, but in most cases I am unable to find enough informations, documantation or anything.
PostgreSQL is really great(but sometimes a little slow...), but it would need a better documentation. For example a complette reference for the built-in functions, aggregate functions and for the PgPL/SQL language
The developers also would have to concentrate on the speed of the DBMS, thus storec procedures written in PgPL/SQL are very slow. They are really.
Looking forward for your reply,
Re: PGSQL 7.0
%I was slated
> to replace a MySQL backend with Oracle
> on Linux this evening
LOL - well all I can say there is "may the force be with you" I've been fighting with Oracle (9i)'s installer for a week now - it took me an hour just to get the installer to run, you have to go and do half the changes yourself - (these guys never heard of an install script??). At least I didn't have to go and fetch/try the entire contents of Blackdown's ftp server this time just to find a JRE it would run on - there's progress. And then the installer just fails with no given reason/error at multiple stages throughout the install. This shoddiness amazes me! When you consider that big projects like Apache, MySQL, PHP and the like have installed without a hitch on every Linux based OS I have thown them at (some old, some new, various distro's), it is incredible that an organisation such as Oracle can't get their installation processes sorted. The amount of fixing I've had to do just to get the installer to run does not bode well for the reliability of the products it installs!
I'd decided to try this and give Oracle a another chance after the disaster-on-a-CD that was OAS but it looks like their products are just as over complicated and half baked as ever. If it won't play ball in a few more days, I'll have to cross that off the list of things we might use in future projects.
Grr - I'll be alright after I take my pills.. :)
PostgreSQL is a very solid DB
I have found PostgreSQL to be a fast and reliable DB. It has alot of features and I'm continued to be amazed at how well it performs on some vey complex queries.
Go team !
testing against SAP DB
ne1 has already ran a performance test of
PostgreSQL against SAP DB ( recently GPL'ed ) ?
maybe i'll do it... really need a "state-of-art" transaction-safe GPL DBMS.
( www.sapdb.org )
Re: Performance issues
We are now using PostgreSQL 7.1.2 on a dual PIII/1gHz server with 1gb RAM for the past month.
The performance is much improved (both reads and writes) over 7.0.x. Coupled with pgAdmin, this database has some serious capabilities.
Re: PostGreSql may not be as "free" as you think !
> To all who may concern:
> I am afraid to tell you that the
> POSTGRESQL is not as FREE as you
> The FTP server for postgreesql
> (ftp.postgresql.org) no longer
> permits non-member to log-on.
> I am sadden by this turn of event.
PostGreSql may not be as "free" as you think !
To all who may concern:
I am afraid to tell you that the POSTGRESQL is not as FREE as you think.
The FTP server for postgreesql (ftp.postgresql.org) no longer permits non-member to log-on.
I am sadden by this turn of event.
Re: Performance issues
We have been using PostgreSQL 7.0.3 on a quad XEON server
with 1gb RAM for about 5-months now. While the ODBC/SQL
is excellent as far as setup and compatibility, the performance
is not. I would still recommend it for any serious database
application that cannot afford commercial licensing.
I was playing around with 7.0 on my laptop the other day (P-90, w/ 40 megs RAM and rh6.0) and I was not very impressed with the speed factor of it. I have been using MySQL for close to a year now, I need something less restrictive. ( as far as the license )
Postgre has many features that the dbs don't have, for example, sub querys. But, MySQL is much much quicker. I plan on doing some testing on a AMD-500 dedicated server soon, I am hoping that the performance with PHP will be better.
Besides that, I think its a great db, but, needs more work. For general toying around and small to medium sites. Postgre is great. But, for big high trafic sites. I would not recommend it.
Tools to access to a server's filespace and printers via SMB.
A C language version of lzip.