| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
| Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Hope for a new PostgreSQL era? |
| Date: | 2011-12-11 03:29:33 |
| Message-ID: | CAOR=d=2iXxkBYmS9qC83m38W5RjuqOV3u-VMb-VLy3eBKXucKQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Dec 10, 2011 at 7:28 PM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2011-12-11 06:19:07 | Re: Hope for a new PostgreSQL era? |
| Previous Message | Craig Ringer | 2011-12-11 02:28:00 | Re: Hope for a new PostgreSQL era? |