From: Bruce Momjian <bruce@momjian.us>
Message-Id: <201102042317.p14NHCK12314@momjian.us>
Subject: Re: [HACKERS] Slow count(*) again...
In-Reply-To: <4D4B231C.3030802@vmsinfo.com>
To: Mladen Gogala <mladen.gogala@vmsinfo.com>
Date: Fri, 4 Feb 2011 18:17:12 -0500 (EST)
CC: Chris Browne <cbbrowne@acm.org>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

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. +