John Aughey <[EMAIL PROTECTED]> writes:
> However, this next one is slow.
> calendar=# explain select * from schedule where schedule.owner_id in
> (select group_id from groups where user_id=101);
IN is not very well implemented at present. You could try something
like this (in 7.1):
select sch
I'm stress testing my application by creating large data sets. This
particular query selects rows from the schedule table that have a specific
owner_id. (I'll show you the results of explain)
calendar=# explain select * from schedule where schedule.owner_id=101 or
schedule.owner_id=102;
Index S
