[PERFORM] Inheritance, unique keys and performance

2008-01-12 Thread Julian Scarfe
Useing 8.1.9 I'm running into some performance issues with inheritance. I've abstracted the situation below because otherwise there's lots of spurious stuff, but I'll gladly provide the real EXPLAIN ANALYZE output if necessary. I have a superclass and a dozen subclasses, of which I've picked o

Re: [PERFORM] Inheritance, unique keys and performance

2008-01-12 Thread Tom Lane
"Julian Scarfe" <[EMAIL PROTECTED]> writes: > Useing 8.1.9 I'm running into some performance issues with inheritance. > I've abstracted the situation below because otherwise there's lots of > spurious stuff, but I'll gladly provide the real EXPLAIN ANALYZE output if > necessary. Without the EXP