From: | "dave(dot)" <dave(dot)para(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Automatic partitioning, |
Date: | 2008-02-18 12:52:16 |
Message-ID: | 15544618.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm working on a database which have big tables and one of the tables is
expected to grow very fast so we need to use partitioning. the problem is
that I can't find a solution to do the partitioning automatically, I mean
what postgres docs describe at (5.9. Partitioning) is not suitable because
we need database create new tables as needed -plus updating rules and etc-.
In this particular table we want to partition by id column. On other side
because of existing jpa code it's not so easy to use procedures for making
it automatic. For another database I already created a procedure in plsql
which create new inherited tables as needed -for partitioning- but in this
database it's not possible to use a similar solution.
Is there any solution to implement partitioning and database create new
inherited tables as needed?
Best.
--
View this message in context: http://www.nabble.com/Automatic-partitioning%2C-tp15544618p15544618.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Enrico Sirola | 2008-02-18 12:56:55 | Re: Vertical and Horizontal Table Partition |
Previous Message | T.J. Adami | 2008-02-18 12:18:23 | Vertical and Horizontal Table Partition |