To be honest, it looks like you might need a schema adjustment. Normalization means keeping one kind of thing in one place, avoiding
ugly queries. Inheritance can also help with this too.
Alex Turner NetEconomist
Hi,
The schema started off with all the data in one place as you described but in this case I kind of had to split out the data into different tables in order to win pretty major performance gains elsewhere. By Inheritance you mean using pkeys and such, right? I haven't looked into using pkeys and such yet... I haven't seen a compelling reason to in my app yet, this may be it?
Thanks for your reply!
Madison
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
