[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 18:52:52 +0200
User-agent: Mutt/1.5.23 (2014-03-12)

On Thu, Jun 05, 2014 at 04:33:46PM +0000, Jim Busser wrote:

> In both cases, the website tab "Stats" shows a ""Hash Left Join" as taking 
> 3.9 seconds:

Indeed. The probable reason for that is the Sequential
(rather than Index) Scan PostgreSQL is running against and dem.org_unit. Looking at the "HTML" tab the hash
condition is listed to include .fk_category -- for which we
had been lacking an index. I have, as written earlier, now
added those indices.

Attached find a file you can run against your v19 database in
order to manually add those indices. The file will be part of
the next bugfix release. Given the new indices PostgreSQL is
likely to pick a better query execution plan.

Please re-run the last queries I sent and post them to so we can be sure it made an improvement.

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

Attachment: v19-dem-org-idx-fixup.sql
Description: application/sql

reply via email to

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