Re: Hope for a new PostgreSQL era? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Hope for a new PostgreSQL era?
Date
Msg-id CAOR=d=2iXxkBYmS9qC83m38W5RjuqOV3u-VMb-VLy3eBKXucKQ@mail.gmail.com
Whole thread Raw
In response to Re: Hope for a new PostgreSQL era?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
On Sat, Dec 10, 2011 at 7:28 PM, Craig Ringer <ringerc@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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Hope for a new PostgreSQL era?
Next
From: Greg Smith
Date:
Subject: Re: Hope for a new PostgreSQL era?