Re: table partioning performance - Mailing list pgsql-performance

From Steven Flatt
Subject Re: table partioning performance
Date
Msg-id 357fa7590701101300m2812545k1487ca58e97970ed@mail.gmail.com
Whole thread Raw
In response to Re: table partioning performance  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: table partioning performance  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-performance
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
 

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Performance of PostgreSQL on Windows vs Linux
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Partitioning