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

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Eugene <evgenius(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: POSTGRES DB 3 800 000 rows table, speed up?
Date: 2006-01-03 14:38:03
Message-ID: bc2lr1prsj6uu214h4jer64uelk1o4d55r@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 27 Dec 2005 23:25:37 +0200, Eugene <evgenius(at)hot(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2006-01-03 14:42:08 Re: generic way to retrieve array as rowset
Previous Message Albert Vernon Smith 2006-01-03 14:36:56 insert serial numbers