Skip site navigation (1) Skip section navigation (2)

Re: Syntax for partitioning

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Syntax for partitioning
Date: 2009-10-29 22:10:57
Message-ID: 1256854257.9673.1.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On tor, 2009-10-29 at 11:15 +0900, Itagaki Takahiro wrote:
> Range partitioning:
>   CREATE TABLE table_name ( columns )
>     PARTITION BY RANGE ( a_expr )
>     (
>       PARTITION name VALUES LESS THAN [(] const [)],
>       PARTITION name VALUES LESS THAN [(] MAXVALUE [)] -- overflow partition
>     );

Maybe this needs to mention the actual operator name instead of LESS
THAN, in case the operator is not named < or the user wants to use a
different one.

> Hash partitioning:
>   CREATE TABLE table_name ( columns )
>     PARTITION BY HASH ( a_expr )
>     PARTITIONS num_partitions;
> 
>   CREATE TABLE table_name ( columns )
>     PARTITION BY HASH ( a_expr )
>     (
>       PARTITION name,
>       ...
>     );

Unless someone comes up with a maintenance plan for stable hash
functions, we should probably not dare look into this yet.



In response to

Responses

pgsql-hackers by date

Next:From: Jeff DavisDate: 2009-10-29 22:19:42
Subject: Re: Syntax for partitioning
Previous:From: Robert HaasDate: 2009-10-29 21:34:47
Subject: Re: Hy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group