At 02:17 PM 7/20/02 +0900, Curt Sampson wrote: >Have you tried it using the standard relational method of doing this? >(I.e., you put the common fields in one table, and the extra fields in >other tables, along with a foreign key relating the extra fields back >to the main table.) That would more accurately replacate what you were >doing with inheritance. > >I have a suspicion, in fact, that inheritance may just be syntatic sugar >for doing this and adding a couple of views. :-)
Yes, I thought this was the case too. I haven't specifically setup foreign keys, but I was under the impression that the "INHERITS" command would do this. >Anyway, it could be that by denormalizing the data (copying it to the >other tables), you reduced the number of joins you do, and so you got a >performance increase. Yes, I guess this is probably the case although it speaks against normalizing too much. I guess too much of a good thing is bad. -Tony ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
