Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 330D92E322F for ; Wed, 2 Jan 2008 12:40:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10289-01 for ; Wed, 2 Jan 2008 12:40:22 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 786052E310A for ; Wed, 2 Jan 2008 12:40:22 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so1354972wxc.28 for ; Wed, 02 Jan 2008 08:40:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=TzKVJ+grnB2ewlZ5osKSPrbRr4nxXs2ufgSBnOUr4uI=; b=Z1Aj+zJOt0O5eQdH/xBGQNvvU4K598TUsqjrZFJIChMJ6bYP1niIMbxwBpL39RErUO5g4wknsYpVqn7OoJSFbt1xGEGaJ4z5P7KDW8SJBRn23B6h71o789VahFlpK/To/szrIXZeH/1HiQnbjoim5CcVoQUmCJ1rG5tPkAcMzz0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=AI+wf+7wv2nsd1NzJ9f3kJF3FrefA/EdWGFApDuahsAGzoLa0gH0h102lz8WbJy9NzajaZQa2p6qcvlkVm7DO9wFJbTNDc0XHDzUXW9nYkyqcc7J4WUj878kDPvUojxGu+DcWlybntmkXrOWR4bkU0ho4BAY55cYA5VB/l8Q/n8= Received: by 10.150.155.1 with SMTP id c1mr3819875ybe.85.1199292021750; Wed, 02 Jan 2008 08:40:21 -0800 (PST) Received: by 10.151.11.9 with HTTP; Wed, 2 Jan 2008 08:40:21 -0800 (PST) Message-ID: <1d219a6f0801020840k27e076d9s913e5855a591ddd2@mail.gmail.com> Date: Wed, 2 Jan 2008 11:40:21 -0500 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: Is there a limit to the number of partitions? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13465_1214905.1199292021740" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/19 X-Sequence-Number: 27793 ------=_Part_13465_1214905.1199292021740 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Is there a limit to the number of partitions a table can have in PostgreSQL? The reason I as is we are looking again at partitioning our databases with the possibility of doing the partitioning by year, month, or even day. However, we are required by HIPPA to keep 7 years of data, and we are planning on maintaining the data online in our databases. While I can't imagine year or month being a problem, 7 years of daily partitions would be 2555+ partitions per table. Can PostgreSQL handle this many partitions per table? Is that feasible, or would the cost of the rules become to expensive to be feasible? Thanks for any comments. Chris ------=_Part_13465_1214905.1199292021740 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Is there a limit to the number of partitions a table can have in PostgreSQL?

The reason I as is we are looking again at partitioning our databases with the possibility of doing the partitioning by year, month, or even day.  However, we are required by HIPPA to keep 7 years of data, and we are planning on maintaining the data online in our databases.  While I can't imagine year or month being a problem, 7 years of daily partitions would be 2555+ partitions per table.  Can PostgreSQL handle this many partitions per table?  Is that feasible, or would the cost of the rules become to expensive to be feasible?

Thanks for any comments.

Chris
------=_Part_13465_1214905.1199292021740--