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

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Mladen Gogala <mladen.gogala@vmsinfo.com>
Cc: Chris Browne <cbbrowne@acm.org>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2011-02-04T23:17:12Z
Lists: pgsql-hackers, pgsql-performance
Mladen Gogala wrote:
> Chris Browne wrote:
> > Well, the community declines to add hints until there is actual
> > consensus on a good way to add hints.
> >   
> OK. That's another matter entirely.   Who should make that decision? Is 
> there a committee or a person who would be capable of making that decision?
> 
> > Nobody has ever proposed a way to add hints where consensus was arrived
> > at that the way was good, so...
> >   
> 
> So, I will have to go back on my decision to use Postgres and 
> re-consider MySQL? I will rather throw away the effort invested in 

You want to reconsider using MySQL because Postgres doesn't have hints. 
Hard to see how that logic works.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +