Re: [PERFORM] order by index, and inheritance

2004-04-26 Thread Michiel Meeuwissen
no inheritance, because at least it is clear what works then). Michiel btw. Why are these messages not appearing on the list itself? -- Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] () ---(end of broadcast)---

Re: [PERFORM] order by index, and inheritance

2004-04-26 Thread Michiel Meeuwissen
Rod Taylor <[EMAIL PROTECTED]> wrote: > On Thu, 2004-04-22 at 07:02, Michiel Meeuwissen wrote: > > Rod Taylor <[EMAIL PROTECTED]> wrote: > > > The scan is picking the best method for grabbing everything within the > > > table, since it is not aware that we

[PERFORM] order by index, and inheritance

2004-04-19 Thread Michiel Meeuwissen
es mm_mediasources (cost=0.00..1.11 rows=1 width=89) Filter: (number = 606973) (3ms) I suppose seq scans are used on the extensions because they contain so few records. All tables have index on number. How do I force it to use them also when I use order by? I use