Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B1E7F9F99C1 for ; Sat, 18 Aug 2007 12:33:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21504-08 for ; Sat, 18 Aug 2007 12:33:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 608B69F9977 for ; Sat, 18 Aug 2007 12:33:21 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so534226nfh for ; Sat, 18 Aug 2007 08:33:20 -0700 (PDT) DKIM-Signature: a=rsa-sha1; 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; b=VYolvOPCMGZViiFlLhfS9qEb8Dt6O+D61H3JA09K68spSJuXhVMg2PlterAm9qyw/aPGQqlEGhTM7CYqA0OaQY03EDD/UnXpZhbwCE5/87KsrmCbm/TkTgYSKVPugzha7Iz91yiHN3EJ3jE10+2/KEkXhHo6+01dkNNZnZPHeYg= 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=lHrCy9tOQMKe9vdJiQqknULM21NJBGESfUI4a7rHlkE2zepr0w58T8UyDHuUu4DuMS3xl+7WiNb88TLTBb7yxWja+muVcJd0rVSdvijtayZjF92Rd10vX7lq6qqRpY/4EE5GE2C+APWhNYcG5Vm9GIeySlt/wTEvqv6Tt4eavv0= Received: by 10.78.132.2 with SMTP id f2mr1316069hud.1187451199980; Sat, 18 Aug 2007 08:33:19 -0700 (PDT) Received: by 10.78.107.5 with HTTP; Sat, 18 Aug 2007 08:33:19 -0700 (PDT) Message-ID: Date: Sat, 18 Aug 2007 09:33:19 -0600 From: "Josh Tolley" To: "=?ISO-8859-1?Q?Julio_Cesar_S=E1nchez_Gonz=E1lez?=" Subject: Re: Partitioning Cc: pgsql-general@postgresql.org In-Reply-To: <1187424557.6772.5.camel@andromeda> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1187424557.6772.5.camel@andromeda> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/1126 X-Sequence-Number: 118975 On 8/18/07, Julio Cesar S=E1nchez Gonz=E1lez wrote: > Hi guys, > > It's natural what master table in the partitioning table contain data > (http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html) ? > or to be empty. I'm no partitioning expert, but I would say most of the time the parent table is supposed to be empty. That said, partitioning schemes need to be developed based on what data you have and what exactly you're trying to do. If you're using the common example of keeping a bunch of historical data where partitions represent a distinct chunk of time (for instance, one partition for every month of data) you probably want to keep the parent table empty. Every row has a date, and so there's a child table for each row naturally, so it doesn't make sense to put anything in the parent tables. But I'm sure someone can come up with a scheme where having data in the parent is also useful. - Josh