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

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 <scott(dot)marlowe(at)gmail(dot)com>
wrote:

> On Tue, Aug 1, 2017 at 6:41 AM, Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>
> 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
>