| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Declarative partitioning |
| Date: | 2015-08-24 12:53:01 |
| Message-ID: | 55DB13AD.1060808@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 08/24/2015 03:46 AM, Simon Riggs wrote:
>
>
> ALTER TABLE foo ADD PARTITION NEXT;
>
> when a sequence of partitions has been defined
>
>
Or perhaps
ALTER TABLE foo ADD PARTITION NEXT nn;
So you can set up, say, a week's worth of daily partitions at once.
I could also imagine a variant that allows you to specify partitions up
to the one including some value.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-08-24 13:50:24 | Re: exposing pg_controldata and pg_config as functions |
| Previous Message | Andrew Dunstan | 2015-08-24 12:47:57 | Re: psql - better support pipe line |