[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 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
- Re: [Gnumed-devel] Praxis encounter location slow to populate, (continued)
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Busser, Jim, 2014/06/05
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/05
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Busser, Jim, 2014/06/05
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/10
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/10
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Busser, Jim, 2014/06/10
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/11
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Busser, Jim, 2014/06/11
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/12
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/12
- Re: [Gnumed-devel] Praxis encounter location slow to populate,
Karsten Hilbert <=
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Sebastian Hilbert, 2014/06/13
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/14
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/16
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/16
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Busser, Jim, 2014/06/16
- Re: [Gnumed-devel] Praxis encounter location slow to populate, Karsten Hilbert, 2014/06/16