Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!newsfeed.straub-nv.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Postgresql hints Date: Mon, 9 Feb 2015 05:27:15 +0000 (UTC) Organization: A noiseless patient Spider Lines: 52 Message-ID: References: <04f51878-3399-48be-84b7-d4548d78887f@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Mon, 9 Feb 2015 05:27:15 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="9dbb49b777b4f27f09e09421fc52f8c8"; logging-data="15680"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/xf2eH+5VrZZ5jvIL+gJTU" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:XVDx1uAImmbOGP+XMflApAxYpm8= Xref: csiph.com comp.databases.postgresql:629 On Mon, 02 Feb 2015 12:52:50 -0800, johannes falcone wrote: > On Sunday, February 1, 2015 at 1:02:35 AM UTC-5, Mladen Gogala wrote: >> I noticed that PostgreSQL now has hints: >> >> http://pghintplan.sourceforge.jp/pg_hint_plan.html >> >> That's a praiseworthy development. A decent partitioning and some >> built-in parallelism may eventually turn PostgreSQL into a usable >> database. This is a monumental progress since this: >> >> http://it.toolbox.com/blogs/database-soup/why-postgresql-doesnt-have- query-hints-44121?rss=1 >> >> Now PgSQL has query hints. Obviously, the times, they are changing: >> >> https://www.youtube.com/watch?v=e7qQ6_RV4VQ >> >> -- >> Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com Je suis >> Charlie > > hints were shot down as idiotware in other rants Well, somebody has obviously wanted that "idiotware" enough to actually implement it: http://pghintplan.sourceforge.jp/pg_hint_plan.html There are even RPM packages in the sourceforge.jp download area, the installation is very easy. And I am not sure about the idiotware. Are you calling people who have purchased EnterpriseDB idiots? Or are you calling idiots the developers who work for EnterpriseDB and who have implemented hints? Are you referring to Bruce Momjian? I disagree with Bruce about many things, but I wouldn't just call him an idiot, despite the fact that he works for the company that has put hints in their DB product. Of course, PostgreSQL has many other shortcomings, like bad partitioning and the lack of any internal parallelism, so EnterpriseDB is not very successful, but hints are actually one of the more useful things done by EnterpriseDB. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com Je suis Charlie