Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioning a table by integer value (preferably in place) - Mailing list pgsql-general

From Pól Ua Laoínecháin
Subject Re: Partitioning a table by integer value (preferably in place)
Date
Msg-id CAF4RT5QGYi2rYNXJP9HUVAyygGJ36BbWincXCKzTqVXHLkJGVQ@mail.gmail.com
Whole thread Raw
In response to Partitioning a table by integer value (preferably in place)  (Pól Ua Laoínecháin <linehanp@tcd.ie>)
Responses Re: Partitioning a table by integer value (preferably in place)
List pgsql-general
Tree view 
Hi again all,

Just a quick follow-up - could I script the creation of 1000
partitions using bash or PL/pgSQL? I think (rightly/wrongly?) that
this may be the best solution?

I've found samples on the web, but they are for partitioning by date -
a quick sample by integer would be gratefully received!

Is partman recommended by the community?

TIA and rgs,

Pól...

pgsql-general by date:

Previous
From: Pól Ua Laoínecháin
Date:
Subject: Partitioning a table by integer value (preferably in place)
Next
From: Ron
Date:
Subject: Re: Partitioning a table by integer value (preferably in place)