date - range - Mailing list pgsql-performance

From H.J. Sanders
Subject date - range
Date
Msg-id KIEBKBGIGGNDKKJJNKCFKEPLEEAA.hjs@rmax.nl
Whole thread Raw
Responses Re: date - range  (Michael Fuhr <mike@fuhr.org>)
Re: date - range  (Mischa <mischa.Sandberg@telus.net>)
List pgsql-performance
Anybody a solution for the next problem:

people can subscribe to a service for 1 or more days (upto a max. of 365).

So in the database is stored: first_date and last_date

To select which people are subscribed for a certain date (e.g. today) we use
a select like

select   ....... where first_date <= today and last_date >= today

Whatever index we create system always does a sequential scan (which I can
understand).

Has someone a smarter solution?

All suggestions will be welcomed.



pgsql-performance by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: Follow-Up: How to improve db performance with $7K?
Next
From: Mike Rylander
Date:
Subject: Re: How to speed up word count in tsearch2?