Hello Sumeet,
Compare schema on both database to make sure there is no mismatches. And
verify LOCKs. if all looks good,
do analyze on newly created database before start execution. This will help
you. New database doesn't have any stats for generate execution plan.
Thanks & Regards,
Naveen Kuma
On Tue, Aug 1, 2017 at 8:45 AM, Sumeet Shukla wrote:
> 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
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 be
On Tue, Aug 1, 2017 at 6:41 AM, Sumeet Shukla 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
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
