Re: [PERFORM] Table Partitions: To Inherit Or Not To Inherit

2004-11-16 Thread Josh Berkus
Don, > What's really the difference between this and creating separate tables > with the same column definition without the inherit, and then create a > view to "merge" them together? Easier syntax for queries. If you created completely seperate tables and UNIONED them together, you'd have to

[PERFORM] Table Partitions: To Inherit Or Not To Inherit

2004-11-16 Thread Don Drake
I've read the previous thread on the list regarding partitioning mechanisms and I just wrote a plpgsql function to create the partition tables (by date) as well as another function used to do the insert (it determines which table will be inserted). The creation of the partition tables uses the inh