Horton

Re: [HACKERS] Slow count(*) again...

Mladen Gogala <mladen.gogala@vmsinfo.com>

View thread
From: Mladen Gogala <mladen.gogala@vmsinfo.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2011-02-03T22:12:07Z
Lists: pgsql-hackers, pgsql-performance 
Josh Berkus wrote:
> However, since this system wasn't directly compatible with Oracle Hints,
> folks pushing for hints dropped the solution as unsatisfactory. This is
> the discussion we have every time: the users who want hints specifically
> want hints which work exactly like Oracle's, and aren't interested in a
> system designed for PostgreSQL.  It's gotten very boring; it's like the
> requests to support MySQL-only syntax.
>   
Actually, I don't want Oracle hints. Oracle hints are ugly and 
cumbersome. I would prefer something like this:

http://dev.mysql.com/doc/refman/5.0/en/index-hints.html

That should also answer the question about other databases supporting hints.

-- 
 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com 
The Leader in Integrated Media Intelligence Solutions