| From: | Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Slow count(*) again... |
| Date: | 2011-02-03 22:12:07 |
| Message-ID: | 4D4B2837.6080601@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2011-02-03 22:13:09 | Re: [HACKERS] Slow count(*) again... |
| Previous Message | Pavel Stehule | 2011-02-03 22:10:52 | Re: [HACKERS] Slow count(*) again... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2011-02-03 22:13:09 | Re: [HACKERS] Slow count(*) again... |
| Previous Message | Pavel Stehule | 2011-02-03 22:10:52 | Re: [HACKERS] Slow count(*) again... |