Re: Using Index-only scans to speed up count(*)

From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: cedric(at)2ndquadrant(dot)com
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using Index-only scans to speed up count(*)
Date: 2014-06-07 13:09:00
Message-ID: CABwTF4VA0pge6VpkKNAE828sdPiE0+Om4bB+66SdFBtMjmTG9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jun 7, 2014 at 8:56 AM, Cédric Villemain <cedric(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cédric Villemain 2014-06-07 13:22:16 Re: Using Index-only scans to speed up count(*)
Previous Message Cédric Villemain 2014-06-07 12:56:21 Re: Using Index-only scans to speed up count(*)