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
