Re: Performance issues

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.
>

In response to

Responses

Browse pgsql-performance by date

  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