Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id DC7279FA4D1
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 10 Jan 2007 17:00:11 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 64243-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 10 Jan 2007 16:59:59 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229])
	by postgresql.org (Postfix) with ESMTP id DC6E99F9F49
	for <pgsql-performance@postgresql.org>;
	Wed, 10 Jan 2007 17:00:01 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so229376wxd
	for <pgsql-performance@postgresql.org>;
	Wed, 10 Jan 2007 13:00:01 -0800 (PST)
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:references;
	b=c4mrBt/ZGwYjuRacgIo2KDTvu4VMKpNgkQ3Ouwg76TN4XOk94FKDWxcid8ux57COSn+xC4r5ZWtzQMHLFu7v3pLqb4jPMeDOXdQbkp0UCanWoJdcNlPI8CFoVnH3s9De3OpgQOQNNqI0fRMKiIMUF/KAQkHpHmZmM3qJxWBLNG8=
Received: by 10.70.89.1 with SMTP id m1mr1340015wxb.1168462800998;
	Wed, 10 Jan 2007 13:00:00 -0800 (PST)
Received: by 10.70.102.8 with HTTP; Wed, 10 Jan 2007 13:00:00 -0800 (PST)
Message-ID: <357fa7590701101300m2812545k1487ca58e97970ed@mail.gmail.com>
Date: Wed, 10 Jan 2007 16:00:00 -0500
From: "Steven Flatt" <steven.flatt@gmail.com>
To: "Simon Riggs" <simon@2ndquadrant.com>
Subject: Re: table partioning performance
Cc: "Colin Taylor" <colin.taylor@gmail.com>, pgsql-performance@postgresql.org
In-Reply-To: <1168346933.3951.276.camel@silverbirch.site>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13921_11554506.1168462800626"
References: <84d3067d0701062037k3229c9ddjbde73b1fd79ee209@mail.gmail.com>
	<357fa7590701081202p726c049ej61390dd1816d1369@mail.gmail.com>
	<1168346933.3951.276.camel@silverbirch.site>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/153
X-Sequence-Number: 22754

------=_Part_13921_11554506.1168462800626
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 1/9/07, Simon Riggs <simon@2ndquadrant.com> wrote:
>
> If you are doing date range partitioning it should be fairly simple to
> load data into the latest table directly. That was the way I originally
> intended for it to be used. The rules approach isn't something I'd
> recommend as a bulk loading option and its a lot more complex anyway.
>
The problem we have with blindly loading all data into the latest table is
that some data (< 5%, possibly even much less) is actually delivered "late"
and belongs in earlier partitions.  So we still needed the ability to send
data to an arbitrary partition.

Steve

------=_Part_13921_11554506.1168462800626
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div><span class="gmail_quote">On 1/9/07, <b class="gmail_sendername">Simon Riggs</b> &lt;<a href="mailto:simon@2ndquadrant.com">simon@2ndquadrant.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">If you are doing date range partitioning it should be fairly simple to<br>load data into the latest table directly. That was the way I originally
<br>intended for it to be used. The rules approach isn&#39;t something I&#39;d<br>recommend as a bulk loading option and its a lot more complex anyway.<br></blockquote></div>
<div>The problem we have with blindly loading all data into the latest table is that some data (&lt; 5%, possibly even much less) is actually delivered &quot;late&quot; and belongs in earlier partitions.&nbsp; So we still needed the ability to send data to an arbitrary partition.
</div>
<div>&nbsp;</div>
<div>Steve<br>&nbsp;</div>

------=_Part_13921_11554506.1168462800626--