Re: Big disappointment with Postgres
Date: Fri, 04 Feb 2011 18:41:05 +0100
Message-ID: <8r2s1gFrekU1_at_mid.individual.net>
Mladen Gogala wrote on 04.02.2011 14:40:
> I invested quite some time in learning the thing, as it seemed very
> similar to Oracle. Unfortunately, when it came down to the pilot project,
> the mass of the SQL to be ported ultimately required optimizer hints.
> There was simply a mass of SQL, ported to different architecture which
> needed quick& dirty fix, because of the sheer volume and the deadline.
> Unfortunately, Postgres community is run by programming wiz kids who have
> never managed a large database and they sanctimoniously refuse to even
> consider hints.
> Consequently, I have to kill the pilot project. Postgres is, simply, not
> a viable alternative. Not with that attitude, anyway.
>
I have been developing applications backed by DBMS for 20 years now, and I never had the need to use hints (neither on Oracle nor on any other DBMS like rdb/VMS, DB2, SQL Server or Postgres). Hints have always been an absolute no-go and no SQL statement would have passed our quality controls that would only run with hints enabled (except for maybe a total of 10 statements in all those years)
If the only way you can get your stuff to run are hints, then you have some serious flaws in your application and DB design. You should better fix _your_ application than insulting the developers of the Postgres team.
The absolutely inacceptable rude tone with which you have been ranting about this in the Postgres mailing list makes me think it's not that bad at all that you are no longer a member of the Postgres community. Received on Fri Feb 04 2011 - 11:41:05 CST