Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #507

Re: why is postgresql better than mariadb?

Show all headers | View raw

Hi,

Some of the points you raise are pretty interesting and well founded, it
would be so much better if you didn't put as much false statements and
FUD around it.

I still take some time to answer that email in case some poor soul gets
impressed by your very strong statements. I want to remind readers here
that as in the real world, the one who feels the need to talk louder is
not always the one who's saying the most trustworthy story.

Mladen Gogala <gogala.mladen@gmail.com> writes:
> So thee is no reason for MySQL, Mariadb, MS SQL Server, Oracle or DB2 to 
> implement them? Now, that's interesting! Those guys aside, why did 
> EnterpriseDB implement them? 

They have a Marketing department.

> No need for contrived examples and artificial constructions. There are 
> two cases which PostgreSQL optimizer cannot handle well: correlated 
> columns and partitioning. Other deficiencies of partitioning aside, 

True.

> Of course they don't abandon Postgresql in droves. PostgreSQL doesn't 
> have droves of users in the first place. The fact is that the market 
> share of PostgreSQL is very minuscule. And the fact is that it remains so 
> for a reason. The fact is also that both MySQL and MariaDB have more 
> users than PostgreSQL. 

FUD.

Same argument line with Windows, which must be the best OS around
because of its Market Share. Oh well, in 2013 we should talk about
Android really, and iOS maybe?

The main reason why MySQL and forks have more users is historical then
Marketing. Yes, Open Source projects too are influenced by Marketing.

> Again, the main guy on design committee works for EnterpriseDB. 

Wrong.

First, there is no design committee, there's a mailing-list.
Second, there's no main guy, there are contributors and committers.

> and why hints are not good when it comes to PostgreSQL.

Because we want to fix the optimiser. If you query plan is wrong, open a
bug report, and we will fix the query planner and optimiser.

And actually, any PostgreSQL DBA worth is salt knows how to hint
PostgreSQL query planning, with SQL standard tools such as CTEs (WITH
queries) and OFFSET in subquery, for instance.

Mladen Gogala <gogala.mladen@gmail.com> writes:

> To illustrate that, I there were PostgreSQL days in 2011 in NYC and 
> MongoDB days in NYC in 2011. Postgres event was dwarfed by the MongoDB 
> event. That showed me everything I needed to know. Part of the reason why 

FUD from your part and Marketing for explaining what you saw.

> PostgreSQL remains obscure database used by scientific institutions which 
> have very little money and practically nobody else is the fact that it is 
> simply inadequate database

FUD again.

Please realise that what you know of the world outside and the actual
world outside might be different things. What I know of the world
outside is in total contradiction with your statements here.

>. Part of the reason why Postgres is and 
> remains inadequate is the fact that its designers are arrogant enough to 
> try telling their users what they need and what they don't need. The 
> process works the other way around: users ask, designers implement.

What I like the most in the PostgreSQL Community is that PostgreSQL is
developped by people who are actually using it on a daily basis, as DBA
or consultants.

From the inside of the PostgreSQL Community your statement here makes no
sense, it's FUD again. Please take a moment and breathe.

> How come? Would you care to explain a bit? The user you are talking about 
> doesn't understand Oracle and is asking for something that Oracle doesn't 
> need. Are you claiming that PostgreSQL optimizer is so good that it 
> doesn't need hints? Did I understand you correctly?

When all you have is a hammer, every problem you want to solve indeed
looks very much like a nail.

Regards,
-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-08-15 20:20 -0700
  Re: why is postgresql better than mariadb? Jasen Betts <jasen@xnet.co.nz> - 2013-08-17 12:54 +0000
  Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-08-18 21:40 +0200
    Re: why is postgresql better than mariadb? Mario Splivalo <majk@fly.srk.fer.hr> - 2013-09-12 19:57 +0000
      Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-09-12 22:16 +0200
      Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 08:21 +0000
        Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-06 12:10 +0200
          Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 20:44 +0000
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-06 23:17 +0200
          Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-07 18:03 +0200
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-07 18:30 +0200
              Re: why is postgresql better than mariadb? Milo Minderbinder <milo@mmenterprises.invalid> - 2013-10-09 01:51 +0000
            Re: why is postgresql better than mariadb Milo Minderbinder <milo@mmenterprises.invalid> - 2013-10-09 01:46 +0000
              Re: why is postgresql better than mariadb Robert Klemme <shortcutter@googlemail.com> - 2013-10-09 08:41 +0200
                Re: why is postgresql better than mariadb Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:24 +0000
        Re: why is postgresql better than mariadb? Fredrik Jonson <fredrik@jonson.org> - 2013-10-11 12:17 +0000
          Re: why is postgresql better than mariadb? Paul Sephton <prsephton@gmail.com> - 2013-10-14 03:47 -0700
            Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-14 18:52 +0200
              Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:58 +0000
            Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:55 +0000
          Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:50 +0000
            Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 04:07 +0000
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-25 10:09 +0200
            Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-12-07 10:52 -0800
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-12-07 10:58 -0800
  Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 08:24 +0000
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:32 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-29 07:39 -0800
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:33 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-29 09:17 -0800
    Re: why is postgresql better than mariadb? Robert Klemme <shortcutter@googlemail.com> - 2013-12-02 21:18 +0100
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-30 05:59 -0800
    Re: why is postgresql better than mariadb? eric@invalid.com (EricF) - 2013-12-04 04:11 +0000
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:37 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-12-07 02:53 -0800
  Re: why is postgresql better than mariadb? yangnw@live.com - 2014-05-12 08:06 -0700

csiph-web