[PERFORM] SELECT ignoring index even though ORDER BY and LIMIT present

hi, I have a problem space where the main goal is to search backward in time for events. Time can go back very far into the past, and so the table can get quite large. However, the vast majority of queries are all satisfied by relatively recent data. I have an index on the row creation date and

Re: [PERFORM] SELECT ignoring index even though ORDER BY and LIMIT present

seqscan = off for the session, but > that is a Big Hammer for what is probably a smaller problem. > > Bob Lunney > > --- On *Wed, 6/2/10, Jori Jovanovich * wrote: > > > From: Jori Jovanovich > Subject: [PERFORM] SELECT ignoring index even though ORDER BY and LIMIT >