Re: table configuration tweak for performance gain.

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/