Partitioning tables...

From: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To: pgsql-admin(at)postgresql(dot)org
Subject: Partitioning tables...
Date: 2003-07-31 19:22:12
Message-ID: 1059679331.2548.14.camel@joem
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,
I currently have a project which will store roughly 10B records in
postgres which will be inserted at a rate of about 40K/s. While we have
adequate disk storage it is paramount that subsets of the data be
queryable quickly, without hindering the insert process to a crawl.

I know in Oracle you can partition the tables into logical subsets and
was wondering if this was also possible in postgres.

Thanks in advance,
-Joe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Priya Nair 2003-07-31 19:36:14 help needed for performance tuning
Previous Message Daniel Gerardo Lucero Baylon 2003-07-31 19:00:49 Starting PostgreSQL server as root