On Sat, Dec 10, 2011 at 7:28 PM, Craig Ringer <ring...@ringerc.id.au> wrote: > The main issue would be exempting queries that're expected to take longer > than the slow query threshold, like reporting queries, where you wouldn't > want to pay that overhead.
One trick you can use for this is to assign the reporting application a different user and then alter user yada yada to turn off logging of slow queries etc for that user. Since it's often useful to increase work_mem and / or change random_page_cost and so on for a reporting user, it's pretty common to do this anyway. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
