Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!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:58:25 +0000 (UTC) Organization: A noiseless patient Spider Lines: 19 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:58:25 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e4f8def8fb90dfd954091bdd9211c78d"; logging-data="13048"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+hXFDXyuCzu0YHiv7eiXuV" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:u7QXzAG0C3Y8MFRiR9iMsTZnKL0= Xref: csiph.com comp.databases.postgresql:505 On Mon, 14 Oct 2013 18:52:13 +0200, Harry Tuttle wrote: > 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. How come? Would you care to explain a bit? The user you are talking about doesn't understand Oracle and is asking for something that Oracle doesn't need. Are you claiming that PostgreSQL optimizer is so good that it doesn't need hints? Did I understand you correctly? -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com