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

Groups > comp.databases.postgresql > #491

Re: why is postgresql better than mariadb?

Show all headers | View raw

On Sun, 06 Oct 2013 12:10:51 +0200, Dimitri Fontaine wrote:

> No hints means that when a new release is out, you don't have to spend
> time fixing all your hinted queries against the new incompatible set of
> query hints.

It also means that you don't have control over plans produced by the 
optimizer. Since Postgres optimizer has difficulties with things like 
partitioning or correlated columns, that means that it is not possible to 
fix the plan when necessary. The benefit of not having to fix the hints 
does not compensate for not having the control over the generated plans. 
This shortcoming is so big that I migrated one database from PostgreSQL 
to MongoDB, just because of that. When there is one SQL to be fixed 
quickly, because someone is waiting for the application, hints are a 
necessity.

And the "set enable_<method>" command is not a hint. The scope is wrong, 
the scope is the entire session instead of single SQL. Disabling or 
enabling access method when all you want is for one specific SQL 
statement to use one specific index is simply wrong and creates a mess 
for other SQL. That, among other inadequacies of PostgreSQL, is the 
primary reason why PostgreSQL did not catch on. The databases that came 
much later, like MySQL in 3 different flavors or MongoDB wiped the floor 
with PostgreSQL, precisely because of things like that. Funny thing is 
that commercial PostgreSQL versions, like EnterpriseDB or Vertica have 
hints. In other words, you have to pay for hints in the world of Postgres. 
You don't have to pay for them in the world of MySQL. Since hints are so 
indispensable, I will simply neither recommend nor use the database that 
doesn't support them. It's as simple as that.



-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

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

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