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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
