On 10/17/06, Rohit_Behl <Rohit_Behl@xxxxxxxxxxx> 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
