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 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: References: <485d489a-e7a5-4885-9c7d-2d983efef307@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 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