Groups > comp.databases.postgresql > #504

Re: why is postgresql better than mariadb?

Path	csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: why is postgresql better than mariadb?
Date	Fri, 25 Oct 2013 03:55:16 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	24
Message-ID	<pan.2013.10.25.03.55.16@gmail.com> (permalink)
References	<485d489a-e7a5-4885-9c7d-2d983efef307@googlegroups.com> <b7cm9dFsjtfU1@mid.individual.net> <slrnl3475p.flr.majk@fly.srk.fer.hr> <pan.2013.10.06.08.21.30@gmail.com> <slrnl5fr30.g5l.fredrik@biggles.jonson.org> <c45c34bf-bd0f-409b-9741-922569d1a465@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Fri, 25 Oct 2013 03:55:16 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="e4f8def8fb90dfd954091bdd9211c78d"; logging-data="13048"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18VD5DBP8yaMAYfOQCiDQEY"
User-Agent	Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock	sha1:QMslRgfYPivPALCo8V2jHuNUDqM=
Xref	csiph.com comp.databases.postgresql:504

Show key headers only | View raw

On Mon, 14 Oct 2013 03:47:44 -0700, Paul Sephton wrote:

> MLaden sounds very much an example of point 3 in the list of reasons
> against hints:
>  - Encouraging bad DBA habits slap a hint on instead of figuring out the
>  real issue.

I would be interested to know your qualifications as a DBA, when talking 
about "bad DBA habits"? The "real issue" is always under-performing SQL 
which needs to be improved. Sometimes, it is possible to do quickly, 
sometimes it isn't. I can see that you've never had a VP staring over 
your shoulder and asking "is it fixed yet"? I have lived through such 
situations. And they can only be resolved by hints.
Also, how in the world do you propose to deal with correlated columns and 
partitioned tables? PostgreSQL optimizer is atrocious when it comes to 
partitioned tables. 

-- 
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