[GENERAL] Vertical and Horizontal Table Partition

I know that using tablespaces I can create a vertical partition by creating two tables with the same primary key wich stores different columns in each table. However, I need to do some horizontal partition that receives about 2,000,000 records per month. What the best way to perform this horizont

Re: [GENERAL] Vertical and Horizontal Table Partition

inheritance + triggers probably. there's an example on the pgsql documentation Il giorno 18/feb/08, alle ore 13:18, T.J. Adami ha scritto: I know that using tablespaces I can create a vertical partition by creating two tables with the same primary key wich stores different columns in each tab