Re: [PERFORM] Partitioning and performance

2015-05-28 Thread Ravi Krishna
On Thu, May 28, 2015 at 10:31 AM, Ravi Krishna wrote: > I am testing partitioning of a large table. I am doing a range Sorry I forgot to clarify. I am using INHERITS for partioning with check constraing built for range partitioning. -- Sent via pgsql-performance mailing list (pg

[PERFORM] Partitioning and performance

2015-05-28 Thread Ravi Krishna
I am testing partitioning of a large table. I am doing a range partitioning based on a sequence col, which also acts as the primary key. For inserts I am using a trigger which will redirect insert to the right table based on the value of the primary key. Based on my testing, I see that the insert