From: | Vivekanand Joshi <vjoshi(at)zetainteractive(dot)com> |
---|---|
To: | Josh Krupka <jkrupka(at)gmail(dot)com> |
Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Performance issues |
Date: | 2015-03-22 21:50:24 |
Message-ID: | CANwLwau6T2Q0m+giv8iemUfZ8wXqkgO40=wC4KpXrYP=hOtu8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Any documentation regarding how to configure postgresql.conf file as per
individual user?
On 21 Mar 2015 13:10, "Josh Krupka" <jkrupka(at)gmail(dot)com> wrote:
> The other approaches of fixing the estimates, cost params, etc are the
> right way of fixing it. *However* if you needed a quick fix for just this
> report and can't find a way of setting it in Jaspersoft for just the report
> (I don't think it will let you run multiple sql statements by default,
> maybe not at all) there are still a couple more options. You can define a
> new datasource in jasper, point this report to that datasource, and have
> that new datasource configured to not use the nested loops. You could do
> that either by making the new datasource use a different user than
> everything else, and disable nested loops for that user in postgres, or you
> could probably have the datasource initialization process disable nested
> loops.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2015-03-22 22:01:01 | Re: Performance issues |
Previous Message | Roland Dunn | 2015-03-21 10:34:23 | Re: Query RE: Optimising UUID Lookups |