Hi every body,

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. 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 because of existing jpa code and jpa layer itself. 
Is there any solution to implement partitioning and database create new
inherited tables as needed update rules on main table and do other required
steps automatically? 

Any help is appreciated. 
Best.
-- 
View this message in context: 
http://www.nabble.com/partitioning-and-postgres%2C-tp15545607p15545607.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to