Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Date
Msg-id 3073cc9b0812151101h3db74130xb5a808422e48c3f3@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1  (Emmanuel Cecchet <manu@frogthinker.org>)
List pgsql-hackers
On Mon, Dec 15, 2008 at 1:46 PM, Gregory Stark <stark@enterprisedb.com> wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>
>> Hackers,
>>
>> We don't yet seem to have a clear specification for this feature, and the Other
>> Open Source DB has shown us how problematic it is to get auto-partitioning
>> wrong.
>>
>> Should we defer auto-partitioning to 8.5?
>
> If we're serious about having a "next generation" partitioning with a concept
> of partition keys then it seems to me to make more sense to do that first and
> then add on a feature like this.
>

+1

> This is still very useful. I haven't looked at the actual patch, does it
> require core changes or can it be stashed in a pgfoundry or contrib module?
>

what i don't like about this one is that it creates partitions at
create table time and to manually add all new partitions (inherit
tables and modify the trigger)... and what i want to see is an
automatic creation when it's needed...


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Next
From: Alvaro Herrera
Date:
Subject: Re: Block-level CRC checks