leonbloy(at)sinectis(dot)com(dot)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