Well, actually... I shifted to using cursors instead of those LIMIT,
OFFSETS. Things are lightning fast now. In fact in many batch processing
operations, we are going to be using those cursors in the future.
- Ericson Smith
eric@did-it.com
On Mon, 2003-03-10 at 05:45, Mark Kirkwood wrote:
> Richard Huxton wrote:
>
> >
> >
> > I think CPU_INDEX_TUPLE_COST may be your
> >friend (see archives for discussion).
> >
> >
> >
>
> Might be worth looking at RANDOM_PAGE_COST as well ( going down to 1 or
> even fractional values)
>
> best wishes
>
> Mark
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Ericson Smith <eric@did-it.com>