5 ms·
I suppose that you should care if you use it and rely on it for production applications. But if you use a commercial database (or one of the other OSS database
by hvs 17y ago
I suppose that you should care if you use it and rely on it for production applications. But if you use a commercial database (or one of the other OSS databases -- is Postgres any good?) then this doesn't really affect you at all.
- davidw 17y agoPostgres is very good. So much so that many of us use it instead of Mysql in any case:-)
- shiranaihito 17y agoIt may well be very good, but it's much more painful to set up and get running than MySQL.
- davidw 17y agoNo it isn't: apt-get install postgresql Then a few commands to create databases and users and things, and you're good.
- tdavis 17y agoHave the shipped configs improved to the point that you get a production database out of the gate? I've been using (and loving) psql for years, but I've never once trusted the default postgresql.conf.
- tsuraan 17y agoUnder Gentoo, at least, the default postgresql.conf is still garbage. limit of 100 connections, hardly any shared memory, really nothing about it is good. I don't think shipping a good config file is possible though; we need a good config file generator, that looks at kernel configuration and hardware configuration and makes a good config based off that. It doesn't look like such a thing exists though.
- bayareaguy 17y agoDoesn't the Enterprise DB distribution of PostgreSQL include a tuning wizard? http://www.enterprisedb.com/products/postgres_plus/overview.do http://www.enterprisedb.com/products/postgres_plus/overview....
- rbanffy 17y agoLast time I checked on Debian, no. But it was more or less painless - just edit a couple settings on the config files and you are good to go. IIRC, I had to adjust memory footprint (telling PostgreSQL to feel at home and use all it wanted to use) and tell it to trust the disk subsystem and the UPS (turning synchronous writes off). From that point on, it withstood a huge beating.
- shiranaihito 17y agoWell, it got really frustrating after that. It dropped stuff in at least three different directories, and then I had to track down where its config files live, which config happens to contain what, and so on. I changed the data directory, but the new data directory was not "formatted" or something, so I got a hand-wavy error message that naturally said nothing about formatting the new data directory, and so on. All in all, it was a painful experience.
- compay 17y agoThat's likely only a result of your unfamiliarity with Postgres relative to MySQL. Also, installing via apt on any Debian-based Linux is pretty much just as easy with Postgres as it is for MySQL.
- datums 17y agoOne problem with moving to postgres is replication. It's not a drop in replacement. Enterprise DB was working on having the pain of replication scripted.
- shiranaihito 17y ago> That's likely only a result of your unfamiliarity with Postgres relative to MySQL. True, but the first time I ever did anything with MySQL was far less painful than with PostgreSQL. Besides, setting up a database should be easy because it's easy, not because you remember exactly what to do.
- mahmud 17y ago"$FOO is very good. So much so that many of us use it instead of $BAR in any case." Your usage of FOO for some purposes is not a sufficient proof of its superiority to other solutions for all purposes.
- davidw 17y agoI think you have a parse error. I didn't write "Mysql sucks" or that Postgres is better for everything always. Google for Postgres vs Mysql if you're interested in pursuing the topic further - it's been done to death here and elsewhere. I just wanted to say that Postgres is a very valid alternative.
- spudlyo 17y agoCongratulations. In every discussion thread about MySQL there is always one guy who has to mention that PostgreSQL is a superior alternative to MySQL, thus reigniting yet another off-topic discussion of the relative merits of each. Today you are that guy. Today is your day to shine.
- randallsquared 17y agoIt was in response to a direct question. Sheesh.
- tdavis 17y agoPostgreSQL isn't superior to other solutions (in this case MySQL) for all purposes, but it's superior for enough purposes to make it a smart recommendation to those looking for alternatives to MySQL. I've used them both for roughly the same amount of time to varying degrees (5 years or so each) and since switching I've never used MySQL, except where required (hello, Wordpress).
- datums 17y agoIt might not affect you directly, but what about your partners? Apis you might take for granted. Do you sit back and hope they have the expertise to move to a new solution. I think Oracle should embrace the community and benefit from it's contributions.