Postgres Pro
Downloads
Home   >   mailing lists

Re: max() not using index - Mailing list pgsql-general

From Ralph Graulich
Subject Re: max() not using index
Date
Msg-id Pine.LNX.4.21.0207171439080.7918-100000@shauny.shauny.de
Whole thread Raw
In response to Re: max() not using index  ("Peter Gibbs" <peter@emkel.co.za>)
List pgsql-general
Tree view 
Hi Peter,


> >   ->  Seq Scan on dam  (cost=0.00..5442.92 rows=132692 width=4)
> select dam_id from dam order by dam_id desc limit 1;

Thanks alot. That did the trick.


Kind regards
... Ralph ...

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Using index with order desc
Next
From: Manfred Koizar
Date:
Subject: Re: NULL Foreign Key