Re: Rethinking stats communication mechanisms - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Rethinking stats communication mechanisms
Date
Msg-id 87mzca6hb3.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Rethinking stats communication mechanisms  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: Rethinking stats communication mechanisms  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-hackers
Douglas McNaught <doug@mcnaught.org> writes:

> Yeah, but if you turn on query logging in that case you'll see the
> bajillions of short queries, so you don't need the accurate snapshot
> to diagnose that.

Query logging on a production OLTP machine? a) that would be a huge
performance drain on the production system b) it would produce so much logging
that it would take a significant amount of disk and i/o resources just to
handle and c) you would need to implement special purpose tools just to make
sense of these huge logs.


-- 
greg



pgsql-hackers by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Rethinking stats communication mechanisms
Next
From: Arjen van der Meijden
Date:
Subject: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL