Horton

Re: POSTGRES DB 3 800 000 rows table, speed up?

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: Eugene <evgenius@hot.ee>
Cc: pgsql-general@postgresql.org
Date: 2006-01-03T14:38:03Z
Lists: 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