partitioning and postgres,

From: "dave(dot)" <dave(dot)para(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: partitioning and postgres,
Date: 2008-02-18 13:48:50
Message-ID: 15545607.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Browse pgsql-general by date

  From Date Subject
Next Message Hermann Muster 2008-02-18 15:11:14 Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP
Previous Message pgsql_user 2008-02-18 13:14:46 Re: Auto incrementing primary keys