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