X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 39E5FD1C9D9 for ; Thu, 31 Jul 2003 19:22:15 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 74333-04 for ; Thu, 31 Jul 2003 16:21:10 -0300 (ADT) Received: from localhost.localdomain (webe.ne.client2.attbi.com [24.61.34.112]) by svr1.postgresql.org (Postfix) with ESMTP id 6E9E8D1C9C9 for ; Thu, 31 Jul 2003 16:22:12 -0300 (ADT) Received: from joem.mazunetworks.com (klopfer.mazunetworks.com [4.19.249.110]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h6VJN7dD007382 for ; Thu, 31 Jul 2003 15:23:07 -0400 Subject: Partitioning tables... From: Joe Maldonado To: pgsql-admin@postgresql.org Content-Type: text/plain Message-Id: <1059679331.2548.14.camel@joem> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 31 Jul 2003 15:22:12 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/358 X-Sequence-Number: 9698 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