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