[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Praxis encounter location slow to populate

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Praxis encounter location slow to populate
Date: Thu, 5 Jun 2014 21:13:52 +0200
User-agent: Mutt/1.5.23 (2014-03-12)

On Thu, Jun 05, 2014 at 05:48:29PM +0000, Jim Busser wrote:

> On running the script, my terminal showed the appended.
> Should the changes be immediately active?
> I ask because the output of the queries looks unimproved … maybe postgres is 
> failing to take advantage of the index?

Maybe so, perhaps because the LEFT JOIN constrains the
planner more than an INNER JOIN would. Since semantically an
INNER JOIN will do just what is needed I have modified the
relevant views to use that (along with taking out a subquery
not necessary for the v_praxis_branches view.

Please run the attached files against your database (first
the *org* one, then the *branch* one) and re-report the
results of the queries we used to analyze query execution.

Those changes will, again, be part of the next bugfix release.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

Attachment: v19-dem-v_orgs_v_org_units-fixup.sql
Description: application/sql

Attachment: v19-dem-v_praxis_branches-fixup.sql
Description: application/sql

reply via email to

[Prev in Thread] Current Thread [Next in Thread]