Hi, We are planning on implementing partioning in our postgres production database.=20 In my test system I created a table called eventlog which has 7 partitions. I have created rules for data to be inserted in respective partitions. I tested a scenario where in one terminal window I insert rows in the eventlog table in the BEGIN END loop and do not commit the transaction. In another terminal window I create a new partition but when I create a rule for the new partition it hangs until I commit the transaction(insert) in the first terminal window. Just want to know if this is a limitation in postgres partitioning ? Is there a work around for this problem? In our production environment we want to be able to create new partitions and rule for new partition while data is being inserted into the eventlog table. Any workaround, recommedation or help will be highly appreciated. Thanks Paramjeet Bhella -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
