lan with the needless
sort). Second time I ran it without disabling anything, but I modified
ORDER BY to only "thr.id DESC" (deleted "msg.msgid DESC"), to give me
the same plan as before, but without the sort.
PSQL input and output attached.
I think the 50
ght I'd make a test case, that's easy to follow, and
illustrates the problem: that the planner doesn't even consider my
plan. If it did, I think that'd be the one that gets executed. But tell me if
I'm wrong somewhere.
> Make the case. **I** want it is not sufficient...
x27;s no problem for 9 rows, but this is only a test case. In
production there will be much more. I just wanted to show that the
planner doesn't even consider a plan without a sort step, using purely
index scans.
Denes Daniel
st ordering by a
unique key of parent, then something in child? (Except for
child.parent_id, child.something because this has all the information in
child and can rely on a single multicolumn index.)
Denes Daniel
that needless sort?
I'm using PostgreSQL 8.1.8.
Thanks in advance,
Denes Daniel
Olvasd az [origo]-t a mobilodon: mini magazinok a Mobizin-en
___
www.t-mobile.hu/mobizin
-
