Re: Big disappointment with Postgres
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 4 Feb 2011 06:50:29 -0800 (PST)
Message-ID: <3a85b61a-235b-40a8-9f02-6f92cd98bb04_at_f18g2000yqd.googlegroups.com>
On Feb 4, 9:43 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Feb 4, 9:36 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
> > Mladen:
>
> > # Unfortunately, Postgres community is run by programming wiz kids who
> > have never managed a large database and they sanctimoniously refuse to
> > even consider hints.
>
> > Aren't hints in oracle code an extreme example of "extensions" to the
> > SQL language?
>
> > Do any other relational databases support hints?
>
> > Obviously if Oracle supports the database code they are free to
> > introduce proprietary extensions as they see fit into their code base.
>
> > Does MySQL support hinting the way Oracle does?
>
> I know that SQL Server has some optimizer hints available so Oracle is
> definitely not the only vendor to provide developers a means to adjust
> the optimizer plan.
>
> According to the official mySQL manual it also supports hints:http://dev.mysql.com/doc/refman/5.0/en/index-hints.html
>
> HTH -- Mark D Powell --
Date: Fri, 4 Feb 2011 06:50:29 -0800 (PST)
Message-ID: <3a85b61a-235b-40a8-9f02-6f92cd98bb04_at_f18g2000yqd.googlegroups.com>
On Feb 4, 9:43 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Feb 4, 9:36 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
> > Mladen:
>
> > # Unfortunately, Postgres community is run by programming wiz kids who
> > have never managed a large database and they sanctimoniously refuse to
> > even consider hints.
>
> > Aren't hints in oracle code an extreme example of "extensions" to the
> > SQL language?
>
> > Do any other relational databases support hints?
>
> > Obviously if Oracle supports the database code they are free to
> > introduce proprietary extensions as they see fit into their code base.
>
> > Does MySQL support hinting the way Oracle does?
>
> I know that SQL Server has some optimizer hints available so Oracle is
> definitely not the only vendor to provide developers a means to adjust
> the optimizer plan.
>
> According to the official mySQL manual it also supports hints:http://dev.mysql.com/doc/refman/5.0/en/index-hints.html
>
> HTH -- Mark D Powell --
Update - It also appears that postgreSQL has a hint feature: http://www.enterprisedb.com/docs/en/8.3R2/perf/Postgres_Plus_Advanced_Server_Performance_Guide-28.htm
HTH -- Mark D Powell -- Received on Fri Feb 04 2011 - 08:50:29 CST