On Thu, Aug 07, 2014 at 09:39:57AM -0400, Robert Haas wrote:
> On Wed, Aug 6, 2014 at 9:35 PM, Bruce Momjian wrote:
> > On Sun, Jan 12, 2014 at 12:53:40PM -0500, Noah Misch wrote:
> >> Further study revealed a defect in the patch's memory management, and I
> >> have
> >> not gotten around to corr
On Wed, Aug 6, 2014 at 9:35 PM, Bruce Momjian wrote:
> On Sun, Jan 12, 2014 at 12:53:40PM -0500, Noah Misch wrote:
>> On Sat, Jan 11, 2014 at 02:10:01PM -0500, Bruce Momjian wrote:
>> > On Mon, Jun 3, 2013 at 03:07:27PM -0400, Noah Misch wrote:
>> > > A colleague, Korry Douglas, observed a table
On Sun, Jan 12, 2014 at 12:53:40PM -0500, Noah Misch wrote:
> On Sat, Jan 11, 2014 at 02:10:01PM -0500, Bruce Momjian wrote:
> > On Mon, Jun 3, 2013 at 03:07:27PM -0400, Noah Misch wrote:
> > > A colleague, Korry Douglas, observed a table partitioning scenario where
> > > deserializing pg_constrai
On Sat, Jan 11, 2014 at 02:10:01PM -0500, Bruce Momjian wrote:
> On Mon, Jun 3, 2013 at 03:07:27PM -0400, Noah Misch wrote:
> > A colleague, Korry Douglas, observed a table partitioning scenario where
> > deserializing pg_constraint.ccbin is a hot spot. The following test case, a
> > simplificati
On Mon, Jun 3, 2013 at 03:07:27PM -0400, Noah Misch wrote:
> A colleague, Korry Douglas, observed a table partitioning scenario where
> deserializing pg_constraint.ccbin is a hot spot. The following test case, a
> simplification of a typical partitioning setup, spends 28% of its time in
> stringT
On Fri, Jun 07, 2013 at 11:58:14AM +0530, Amit Kapila wrote:
> So the memory increase number's would like:
>
> Example for 64-bit m/c
> In database, there are 100 tables, each having 2 constraints and 30 live
> connections
>
> Size increase = no. of tables * size of (Node*) * number of constraint
On Friday, June 07, 2013 2:10 AM Noah Misch wrote:
> On Thu, Jun 06, 2013 at 07:02:27PM +0530, Amit Kapila wrote:
> > On Tuesday, June 04, 2013 12:37 AM Noah Misch wrote:
>
> > This patch can give good performance gain in the scenario described
> by you.
> > Infact I had taken the readings with pa
On Thu, Jun 06, 2013 at 07:02:27PM +0530, Amit Kapila wrote:
> On Tuesday, June 04, 2013 12:37 AM Noah Misch wrote:
> This patch can give good performance gain in the scenario described by you.
> Infact I had taken the readings with patch, it shows similar gain.
Thanks for testing.
> This patch
On Tuesday, June 04, 2013 12:37 AM Noah Misch wrote:
> A colleague, Korry Douglas, observed a table partitioning scenario
> where deserializing pg_constraint.ccbin is a hot spot. The following
> test case, a simplification of a typical partitioning setup, spends 28%
> of its time in
> stringToNode
