[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: Fri, 13 Jun 2014 00:18:34 +0200
User-agent: Mutt/1.5.23 (2014-03-12)

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

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

reply via email to

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