Re: reason for default PGSTAT_ACTIVITY_SIZE - Mailing list pgsql-general

From Frank Joerdens
Subject Re: reason for default PGSTAT_ACTIVITY_SIZE
Date
Msg-id 7d10d2df1001051136s65d60a1fl82b0b6e8810271cd@mail.gmail.com
Whole thread Raw
In response to Re: reason for default PGSTAT_ACTIVITY_SIZE  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: reason for default PGSTAT_ACTIVITY_SIZE
List pgsql-general
On Tue, Jan 5, 2010 at 6:24 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
[...]
>> Is there a good reason to set PGSTAT_ACTIVITY_SIZE at 256 and is my
>> only option to recompile the server? Is there a practical
>> limit/drawback to making the variable say 4 or 8 times the default?
[...]
> On current releases, it has a higher value (1024 IIRC). And it's a
> configuration parameter on 8.4.

A cool that's great news! We'll probably deal with this issue then by
going from 8.3->8.4 asap.

But I just grepped the 8.3 source tree for PGSTAT_ACTIVITY_SIZE and
it's not there? So the value/variable has a different name now?

Cheers,

Frank

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: pl/perl not rethrowing pl/pgsql exceptions
Next
From: Antonio Goméz Soto
Date:
Subject: Re: Using table name in column for joining