Postgres Pro
Downloads
Home   >   mailing lists

Re: Using Index-only scans to speed up count(*) - Mailing list pgsql-hackers

From Gurjeet Singh
Subject Re: Using Index-only scans to speed up count(*)
Date
Msg-id CABwTF4VA0pge6VpkKNAE828sdPiE0+Om4bB+66SdFBtMjmTG9Q@mail.gmail.com
Whole thread Raw
In response to Re: Using Index-only scans to speed up count(*)  (Cédric Villemain <cedric@2ndquadrant.com>)
Responses Re: Using Index-only scans to speed up count(*)  (Cédric Villemain <cedric@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Sat, Jun 7, 2014 at 8:56 AM, Cédric Villemain <cedric@2ndquadrant.com> wrote:
> Le samedi 7 juin 2014 08:35:27 Gurjeet Singh a écrit :
>
>> PS: Please note that I am not proposing to add support for the
>> optimizer hint embedded in Mitsuru's query.
>
> :-)

Even though I (sometimes) favor hints, and developed the optimizer
hints feature in EDB (PPAS), I know how much Postgres **hates** [1]
optimizer hints :) So just trying to wade off potential flamewar-ish
comments.

[1]: http://wiki.postgresql.org/wiki/Todo#Features_We_Do_Not_Want

Best regards,
--
Gurjeet Singh http://gurjeet.singh.im/

EDB www.EnterpriseDB.com

pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Using Index-only scans to speed up count(*)
Next
From: Cédric Villemain
Date:
Subject: Re: Using Index-only scans to speed up count(*)