> Having the choice is a good thing, but I wouldn't want to use a DBMS
> that is so crippled when it comes to SQL features as MySQL (CTE,
> recursive queries, windowing functions, partial indexes, function based
> indexes, check constraints, ...)
Well, many more people are still using MySQL than PostgreSQL. I wonder
> Putting priority on certain features is one thing - everyone has
> different requirements.
Hints have been requested many times, by many people.
> Constantly ranting about the fact that something is missing in a product
> is another thing.
It's far from constantly. As a matter of fact, I haven't been active on
this group for months, which can be easily checked.
> And that's exactly what Mladen is doing - and he only does it in the PG
Postgres groups seem to be the right place to complain about Postgres.
Where do you suggest I should complain about Posgtgres?
Quote:> I have never seen him complain about all the things that MySQL doesn't
MySQL did not adopt bait and switch approach. By that, I mean the
following: I was lead to believe that Postgres is "the most advanced open
source database in the world" and then "forcefully directed" to buy the
proprietary version. When I needed a feature that is really necessary in
project development and supported by all other open source databases. I
refused to play the game and decided to warn any other possible suckers
and prevent them from wasting a fair amount of time to study a product
which doesn't really deserve attention.
I also noticed that these attacks are increasingly personal, dealing with
me personally. I was given the status of "an enemy", almost a religious
approach. Religious approach in the arena of relational databases is
quite strange, which is one more reason for being very careful when
I am an Oracle DBA with a very long history and a reputation to match. It
is in my power to vote for or against open source products to evaluate.
My CIO usually respects my opinion. I am exactly the kind of person that
software vendors are trying very hard to appease when offering software.
Trying to exorcise me from the Postgres community only shows how bad
things are and what kind of single-minded religious zealots rule the
church of Postgres these days.
There is something badly broken in Postgres community because MySQL is
much more heavily used than Postgres, despite all of its deficiencies.
The sheer number of users is sufficient to prove that statement beyond
I know that this will not make me very popular with the Postgres
faithful, but this database will wither and die, unless something is
done. I am afraid, however, that nothing can be done. Postgres is still
heavily influenced by Michael Stonebraker, who has already been beaten by
Oracle an is on its way to lose the rematch as well. May Stonebraker be
with you, my friend.
Instead of adding ridiculous features like range types or pg_dump which
can use both the primary and the standby at the same time, Postgres
developers would do well to add hints and parallelism. That would make
the database more popular and them look less ridiculous or religulous, to
use the nice new word coined by Bill Maher.