Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: Backend Sta...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 9545 of 10966
Post > Topic >>

Re: Backend Stats Enhancement Request

by miller392@[EMAIL PROTECTED] (David Miller) Jun 19, 2008 at 08:46 PM

> That's not where the problem is.  The people who will be left holding
> the short end of the stick are the ones who can't raise their SHMMAX
> setting past a couple of megabytes.
> 
> It might be feasible to make pg_stat_activity's max string length
> a postmaster-start-time configuration option.

I am fine with a postmaster-start-time configuration option. It is not as
flexible as I would like, but would serve the immediate need and keep me
from having to 
patch every release of Postgres we install on boxes.

The load on our production servers really prohibits any kind of processing
of the log files locally. We have tried using several log ****pping methods
to process the 
logs on a machine with fewer running processes. These large queries are
generated by a third party tool that we have very limited control over.
Some of the queries 
captured are as large 16K. The queries are poorly written/generated. 


 David Miller
River Systems, Inc.

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 8 Posts in Topic:
Re: Backend Stats Enhancement Request
miller392@[EMAIL PROTECTE  2008-06-19 20:46:36 
Re: Backend Stats Enhancement Request
tom@[EMAIL PROTECTED] (T  2008-06-20 19:36:02 
Re: Backend Stats Enhancement Request
tgl@[EMAIL PROTECTED] (T  2008-06-20 10:49:49 
Re: Backend Stats Enhancement Request
tgl@[EMAIL PROTECTED] (T  2008-06-20 12:48:26 
Re: Backend Stats Enhancement Request
tom@[EMAIL PROTECTED] (T  2008-06-23 03:55:13 
Re: Backend Stats Enhancement Request
alvherre@[EMAIL PROTECTED  2008-06-22 14:34:23 
Re: Backend Stats Enhancement Request
xzilla@[EMAIL PROTECTED]   2008-06-20 19:45:36 
Re: Backend Stats Enhancement Request
tgl@[EMAIL PROTECTED] (T  2008-06-21 01:00:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 14:25:35 CST 2008.