On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote: > The table in question has several thousand rows currently, > planning several million, it has a date time stamp column. > All selects will be on ranges of the date time column. > > I created an index on the dt column, ran ANALYSE then, > EXPLAIN for some queries. > The returned plan was always sequential search. > The SELECT time also indicates sequential search. > > Is there anything I can do to improve SELECT performance > on what is essentially an ordered table? Could you post a query and the EXPLAIN ANALYZE output? We could probably give better advice if we could see what's happening. Have you experimented with lowering random_page_cost? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
