On 10/17/06, Rohit_Behl <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
