Re: timestamped archive data index searches - Mailing list pgsql-general

Hi Stephen,


> SELECT MIN(tstamp) FROM det;
> This used a sequence scan even if I do a SET ENABLE_SEQSCAN to off.
> Shouldn't this also use an index?
[...]

Have a look at the thread I started under "max() not using index". I think
you can do the same trick to work around the min() problem if it's
logical. That'd be:

    SELECT tmstamp FROM det ORDER BY tmstamp ASC LIMIT 1;


Kind regards
... Ralph ...