Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Harry Tuttle Newsgroups: comp.databases.postgresql Subject: Re: why is postgresql better than mariadb? Date: Mon, 07 Oct 2013 18:03:49 +0200 Lines: 23 Message-ID: References: <485d489a-e7a5-4885-9c7d-2d983efef307@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net ikUs1BFiwy7iElo6LX1XsQ9Jx/lhWQTeK0WiqAf1wQJYVNDH8= Cancel-Lock: sha1:QG3jqFdjRZloaBb6O5Ec5T1zJI4= 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: Xref: csiph.com comp.databases.postgresql:493 Dimitri Fontaine wrote on 06.10.2013 12:10: > 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 planner and opimizer bugs are actually fixed as they > as doscovered. > > And if you knew how to use PostgreSQL, you would knew it actually has > some kind of hinting due to SQL standard optimiser barriers constructs > and some implementation details. > > Then again it's all about use cases. Some use cases might be inadequate > and then PostgreSQL isn't the best tool for the job. Yes, that can > happen. Don't feed the troll. Mladen is out on a holy war to bash Postgres wherever he can because he takes that fact that Postgres works differently than Oracle as a personal offense. The fact that hints are apparently the only way he knows to tune a statement, speaks for itself.