Re: POSTGRES DB 3 800 000 rows table, speed up? - Mailing list pgsql-general

On Tue, 27 Dec 2005 23:25:37 +0200, Eugene <evgenius@hot.ee> wrote:
>SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom AND ipto;

If your [ipfrom, ipto] ranges are non-overlapping, you might be able
to exploit that fact by adding something like

    ... ORDER BY ipfrom DESC LIMIT 1

Servus
 Manfred