On Tue, Mar 14, 2006 at 08:50:22AM +0000, Simon Riggs wrote: > Is the issue that the log volume is too high? We might be able to look > at ways to reduce/compress the log volume for duration/statement > logging.
ISTM that for performance analysis there's probably a better alternative than just dumping query statements to a logfile. The information we really want is stuff like: WAL sync's per second Read-only queries per second Queries that modify data per second Transactions per second Blacks written per second (maybe broken down by WAL, heap and index) etc... Doesn't really have anything to do with logging query strings passed into the parser. I know dtrace could be used to provide this kind of info, but it's only on Solaris (and eventually FreeBSD). But it should be possible to provide our own version of that for platforms that don't have something like dtrace. Or perhaps there's some entirely different statistics collection method we could come up with... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
