Re: btree index and max() - Mailing list pgsql-general

leonbloy@sinectis.com.ar wrote:
>
> => explain select max(rid) from facturas;
> NOTICE:  QUERY PLAN:
>
> Aggregate  (cost=21139.66 rows=342414 width=4)
>   ->  Seq Scan on facturas  (cost=21139.66 rows=342414 width=4)
>
> I understand that the query planner cannot be so clever
> to grasp that this particular function (max or min)
> might be evaluated by just travelling the BTREE index.
> Am I correct?

I believe you are unfortunately correct.  :(

Regards,
Ed Loehr