Re: Controlling Server status log download

Morning,
You guys are great! I love the responsiveness. So much better than we get from our paid vendor.

The Dba is setting log to 200meg. So, yes it's still a lot to download.

I'd like to see a function that would disable the log download. Most of the time I'm looking it's to investigate queries that are poorly performing.
The log feature is currently interfering with this use.

Thanks
doug

-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Sent: Saturday, February 06, 2010 5:08 PM
To: rod(at)iol(dot)ie
Cc: Little, Douglas; pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Controlling Server status log download

Le 06/02/2010 17:58, Raymond O'Donnell a écrit :
> On 06/02/2010 16:46, Little, Douglas wrote:
>> Is there a way to turn off the download of the log when using server status.
>> Everytime I open the status module, it downloads the entire log, which right now is over 500meg.
>> Would be nice to cache this data to disk, or download only the last x minutes.
>
> I think it would be a better idea to get your log under control - 500Mb
> of log is rather big.... You should use logrotate or equivalent, or look
> at the log-rotation options in postgresql.conf.
>

Well, even if he used a 100MB, which is quite less, this is still a lot
to download. I agree with Douglas that we should at least add an option
to control this behaviour.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com