Обсуждение: 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 horizontal partition in a single
table?

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 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 horizontal partition in a single
> table?
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend