Thanks Tom! You're a life-saver.
On Fri, 2004-01-23 at 17:08, Tom Lane wrote:
> Orion Henry <[EMAIL PROTECTED]> writes:
> > The queries usually are in the form of, where "user_id = something and
> > event_time between something and something".
>
> > Half of my queries index off of the user_id an
Orion Henry <[EMAIL PROTECTED]> writes:
> The queries usually are in the form of, where "user_id = something and
> event_time between something and something".
> Half of my queries index off of the user_id and half index off the
> event_time. I was thinking this would be a perfect opportunity to
I've got a table with about 10 million events in it.
Each has a user_id (about 1000 users) and a event_time timestamp
covering a 4 year period with about 50% of the events being in the last
year. Some users have only dozens of events. A few have hundreds of
thousands.
The queries usually are in
