Vertical and Horizontal Table Partition

From: "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Vertical and Horizontal Table Partition
Date: 2008-02-18 12:18:23
Message-ID: db08b39b-d72f-4313-8054-6daf6edd330c@n77g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dave. 2008-02-18 12:52:16 Automatic partitioning,
Previous Message Kakoli Sen 2008-02-18 12:15:05 Initdb failed in PostgreSQL 7.3.21