Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Harry Tuttle <SOZRBLNTLEEE@spammotel.com>
Newsgroups: comp.databases.postgresql
Subject: Re: why is postgresql better than mariadb?
Date: Mon, 14 Oct 2013 18:52:13 +0200
Lines: 17
Message-ID: <bc2lppF60baU1@mid.individual.net>
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=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net yGy5ZPZtm2qQ5AQ4rU1iYw+YV+ETMJSYltmiBb2xaCUoz54JU=
Cancel-Lock: sha1:K9BycQcFJRdbNX6CKbUzRYq1cXA=
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: <c45c34bf-bd0f-409b-9741-922569d1a465@googlegroups.com>
Xref: csiph.com comp.databases.postgresql:501

Paul Sephton wrote on 14.10.2013 12:47:
> <snip>
>> ... I encourage you to read this:
>>
>> http://wiki.postgresql.org/wiki/OptimizerHintsDiscussion
>>
>
>
> 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.
>

That discussion actually reminds me of a discussion I once had with a SQL Server user that migrated to
Oracle and who as claiming that Oracle was totally useless because it does not have a NOLOCK hint and that
would be the only way to improve the speed of queries in a high transaction system.