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? Cheers, Frank -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general