On 10/17/06, Rohit_Behl <Rohit_Behl(at)infosys(dot)com> wrote:
> Select events.event_id, ctrl.real_name, events.tsds, events.value, events.lds, events.correction, ctrl.type, ctrl.freq from table events, iso_midw_control ctrl where events.obj_id = ctrl.obj_id and events.event_id > ?::bigint order by events.event_id limit ?
unfortunately parameterized limit statements cause problems due to the
fact the planner has a hard coded 'guess' of 10% of rows returned when
the plan is generated. I mention this everyime query hints proposal
comes up :-).
best you can do is to try turning off seqscan and possibly bitmap scan
when the plan is generated.
merlin