Vertical and Horizontal Table Partition - Mailing list pgsql-general

From T.J. Adami
Subject Vertical and Horizontal Table Partition
Date
Msg-id db08b39b-d72f-4313-8054-6daf6edd330c@n77g2000hse.googlegroups.com
Whole thread Raw
Responses Re: Vertical and Horizontal Table Partition
List pgsql-general
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?

pgsql-general by date:

Previous
From: "Kakoli Sen"
Date:
Subject: Initdb failed in PostgreSQL 7.3.21
Next
From: Enrico Sirola
Date:
Subject: Re: Vertical and Horizontal Table Partition