Partioning in postgres

From: "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Partioning in postgres
Date: 2009-06-29 19:19:17
Message-ID: C84662912D280D4AB5C50100A100F0C50478B11A@ct11exm61.ds.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Broersma 2009-06-29 19:36:29 Re: Partioning in postgres
Previous Message Scott Marlowe 2009-06-29 15:56:11 Re: unable to create new table