Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Postgresql hints Date: Sun, 1 Feb 2015 06:02:00 +0000 (UTC) Organization: A noiseless patient Spider Lines: 19 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Sun, 1 Feb 2015 06:02:00 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="9dbb49b777b4f27f09e09421fc52f8c8"; logging-data="32076"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18w5u6MYYNFlVYSxcGEb68Z" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:4u2OUrPQ+QsZpr7KmOP98p2v81w= Xref: csiph.com comp.databases.postgresql:625 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