On Tue, Jun 30, 2009 at 11:45 AM, Richard
Broersma wrote:
> On Tue, Jun 30, 2009 at 10:26 AM, Bhella
> Paramjeet-PFCW67 wrote:
>
>> We're trying to simulate rolling window concept in postgres with partitions,
>> without impacting application which does concurrent inserts into partitioned
>> table
ent: Monday, June 29, 2009 12:36 PM
> To: Bhella Paramjeet-PFCW67
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Partioning in postgres
>
> On Mon, Jun 29, 2009 at 12:19 PM, Bhella
> Paramjeet-PFCW67 wrote:
>
> > I tested a scenario where in one terminal window I
On Tue, Jun 30, 2009 at 10:26 AM, Bhella
Paramjeet-PFCW67 wrote:
> We're trying to simulate rolling window concept in postgres with partitions,
> without impacting application which does concurrent inserts into partitioned
> tables. We basically need to roll off data from older partition say 7 d
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Monday, June 29, 2009 12:36 PM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Partioning in postgres
On Mon, Jun 29, 2009 at 12:19 PM, Bhella Paramjeet-PFCW67
wrote:
> I tested a scenario wher
On Mon, Jun 29, 2009 at 12:19 PM, Bhella
Paramjeet-PFCW67 wrote:
> 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 th
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 i
