X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4B1AD8B9CF4 for ; Wed, 23 Feb 2005 18:49:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95636-08 for ; Wed, 23 Feb 2005 18:49:06 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 159F28B9CAD for ; Wed, 23 Feb 2005 18:49:06 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j1NImm8p019922; Wed, 23 Feb 2005 10:48:49 -0800 Message-ID: <421CD046.7040208@commandprompt.com> Date: Wed, 23 Feb 2005 10:49:42 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Tomeh, Husam" Cc: pgsql-admin@postgresql.org Subject: Re: Partitioning Option? References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------010206000009090501000508" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/265 X-Sequence-Number: 16433 This is a multi-part message in MIME format. --------------010206000009090501000508 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Tomeh, Husam wrote: >Does PostgreSQL support/allow "partitioning" of objects like tables and >indexes, like Oracle does? > > We support tablespaces but not table partitioning. You can get around this by using namespaces and unions however. Sincerely, Joshua D. Drake >I have searched the docs, but haven't found anything to partitioning. > >Thanks, > >-- > Husam >********************************************************************** >This message contains confidential information intended only for the >use of the addressee(s) named above and may contain information that >is legally privileged. If you are not the addressee, or the person >responsible for delivering it to the addressee, you are hereby >notified that reading, disseminating, distributing or copying this >message is strictly prohibited. If you have received this message by >mistake, please immediately notify us by replying to the message and >delete the original message immediately thereafter. > >Thank you. FADLD Tag >********************************************************************** > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------010206000009090501000508 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------010206000009090501000508--