Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 191AA9FA494 for ; Tue, 9 Oct 2007 11:35:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 74244-10 for ; Tue, 9 Oct 2007 11:35:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 879A49FA397 for ; Tue, 9 Oct 2007 11:35:05 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so101387ugf for ; Tue, 09 Oct 2007 07:35:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ocrST5X/7uRRFiHaBRX3DL5x8/yPYknhoSM91hRpIE8=; b=g8g294sqwG9wzKaHsRZFY99d1+w4n2xPIJ3kheCiA3VR5rT90lhGDiYJ19XngT5bbw8LAE0i1qSmW2JOnrk4/ZB5znAFo1qCtupwMEwqKhatocErnHKgTXlbV+BJ20c6poi81HaJAmxE0Aaxsx8Od/JvoPAhjCcp2xXH2uXv2Ho= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZBMposaFtKA6cWYvyvmzp/r4JFsVciD91AUeB5BdabNLzAPqaFMhTylLwy3sXuimg/b36ieoEVBytjQm6h+gRxuwataHxhoKly9ebPNyaYtmZ4WN+nlhL/1i9+7hagYnsX2crsGemWxmbVjBMqLH5GeuAIS6rAWm5bqFz5xCkgU= Received: by 10.66.221.6 with SMTP id t6mr863584ugg.1191940503366; Tue, 09 Oct 2007 07:35:03 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Tue, 9 Oct 2007 07:35:03 -0700 (PDT) Message-ID: Date: Tue, 9 Oct 2007 09:35:03 -0500 From: "Scott Marlowe" To: info@enricopirozzi.info Subject: Re: Partitioning tables Cc: "pgsql-admin@postgresql.org" In-Reply-To: <20071009160206.3895b3ba.scotty@linuxtime.it> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071009160206.3895b3ba.scotty@linuxtime.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/60 X-Sequence-Number: 26974 On 10/9/07, Enrico wrote: > Hi all, > Is it possible to partition a large table in differtent disks? > > For example > > names from A to K in one disk and from L to Z in another. Yep. Just create file systems belonging to the postgres super user, create tablespaces on those file systems, and then create your inherited tables on those tablespaces as appropriate.