Re: [PERFORM] 2 server with same configuration but huge difference in performance

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Sumeet Shukla <[email protected]>
To: Scott Marlowe <[email protected]>
Cc: pgsql-admin <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: [PERFORM] 2 server with same configuration but huge difference in performance
Date: Tue, 1 Aug 2017 21:15:14 +0530
Message-ID: <CABUL136zJCFv37rLA+yhpWgvAb6iWnp7RGp7VvFBwqoPE9E30Q@mail.gmail.com> (raw)
In-Reply-To: <CAOR=d=0OmV2RwMEqZ2gC2e=tU-RWe0EuSs5QSspGxFP28+xzLw@mail.gmail.com>
References: <CABUL134EOvvkqfoMYWQr05D+VjEVu0cuSHT8rtf-7b6QvGedXQ@mail.gmail.com>
	<CAOR=d=0OmV2RwMEqZ2gC2e=tU-RWe0EuSs5QSspGxFP28+xzLw@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-admin>

It seems that it is happening because of the way the database is created.
On an old database it runs perfectly fine or if I use the old DB as
template to create the new one, it  runs fine. But if I create a new DB
with same settings and permissions it hangs. I'm now trying to find the
difference between these 2 databases.

Thanks & Regards,
Sumeet Shukla


On Tue, Aug 1, 2017 at 9:05 PM, Scott Marlowe <[email protected]>
wrote:

> On Tue, Aug 1, 2017 at 6:41 AM, Sumeet Shukla <[email protected]>
> wrote:
> > Hi,
> >
> > I have 2 PG servers with same h/w and configuration and they are not in
> > replication.
> >
> > On server A it takes 20 minutes to execute the script.
> > On server B it takes more than 20 hours. (Seems to be stuck with create
> > index and and create foreign key steps)
> >
> > Any guidance to troubleshoot this would be highly appreciated.
>
> There's lots of areas where you could be running into problems. I
> suggest reading this wiki page on reporting performance problems.
> It'll help you gather more evidence of where and what the problem is.
>
> https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [PERFORM] 2 server with same configuration but huge difference in performance
  In-Reply-To: <CABUL136zJCFv37rLA+yhpWgvAb6iWnp7RGp7VvFBwqoPE9E30Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox