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

[Karsten Hilbert]

On Thu, Jun 12, 2014 at 06:57:08PM +0200, Karsten Hilbert wrote:

> I'll *also* need dem.state ...
> 
>       pg_dump --data-only --inserts --verbose -d gnumed_v19 -f orgs.sql -U 
> gm-dbo -t dem.state -t dem.urb -t dem.street -t dem.address -t 
> dem.org_category -t dem.org -t dem.org_unit

OK, I was able to load the data into my database.

I am getting pretty much the same plan. However, for me it
"only" takes 2.7 seconds to run.

I would suggest also taking a look at a few PostgreSQL tuning
sites and applying their advice.

        
https://www.google.de/search?ie=ISO-8859-1&hl=de&source=hp&q=postgresql+tuning&btnG=Google-Suche&gbv=1

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346