Date: Tue, 9 May 2017 14:02:42 +0200
From: Vincent Veyron <vv.lists@wanadoo.fr>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Speed differences between two servers
Message-Id: <20170509140242.b7d0fbe8f426aa5ea1f3fd8b@wanadoo.fr>
In-Reply-To: 
 <CAOR=d=3dA7kzeptLJw_dTaAyV4OKKNoVujUcnSOkZLby21eD6g@mail.gmail.com>
References: <20170508194922.b049d1b73c8b681e982cadd9@wanadoo.fr>
	<CAOR=d=2pkqevObyW8ZGFjeAF0WoLEmAEYmehwZSZK5f2qxZMSQ@mail.gmail.com>
	<20170509002441.994488df4bd1a216ec15f8e3@wanadoo.fr>
	<CAOR=d=3h25QxOe9uz_RooJeux4Ok29c-ndF2GnC6_9uZ5qDGGw@mail.gmail.com>
	<CAOR=d=3dA7kzeptLJw_dTaAyV4OKKNoVujUcnSOkZLby21eD6g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Mon, 8 May 2017 17:35:38 -0600
Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Without seeing what your test sql file does I have no idea what the
> big difference in the other direction.=20

It truncates 59 tables, copies data back from a set of text files, inserts =
a few single records and does a few select setval('') to reset the serial c=
olumns.

here it is :
https://pastebin.com/LVsvFzkj

>You'll have to pull out and run
> the individual queries, or turn on auto explain or something to see
> the plans and compare.=20

I used log_duration; it shows that the truncate and all the \copy are much =
slower, while all insert/select statements are twice as fast

>A lot of time it's just some simple tuning in
> postgresql.conf or maybe a database got an alter database on it to
> change something?=20

Server setups are identical : same software, same configurations, same data=
bases.

I've put in a ticket at the Online provider with the data to see if they ha=
ve an answer (now 14H00 in Paris, so they may take a while to respond)


--=20
					Bien =E0 vous, Vincent Veyron=20

https://compta.libremen.com
Logiciel libre de comptabilit=E9 g=E9n=E9rale en partie double


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance