Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #629

Re: Postgresql hints

Show all headers | View raw

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

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

Postgresql hints Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-01 06:02 +0000
  Re: Postgresql hints johannes falcone <visphatesjava@gmail.com> - 2015-02-02 12:52 -0800
    Re: Postgresql hints Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-09 05:27 +0000

csiph-web