Le 05/01/2010 20:36, Frank Joerdens a écrit : > On Tue, Jan 5, 2010 at 6:24 PM, Guillaume Lelarge > <guillaume@xxxxxxxxxxxx> 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? > PGBE_ACTIVITY_SIZE since 8.2. In 8.4, the GUC is named track_activity_query_size. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
