From: Joe Maldonado <jmaldonado@webehosting.biz>
To: pgsql-admin@postgresql.org
Subject: Partitioning tables...
Date: 31 Jul 2003 15:22:12 -0400
Message-ID: <1059679331.2548.14.camel@joem> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jmaldonado@webehosting.biz
Subject: Re: Partitioning tables...
In-Reply-To: <1059679331.2548.14.camel@joem>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox