Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcXSe-0004Gp-8g for pgsql-performance@arkaria.postgresql.org; Tue, 01 Aug 2017 13:43:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dcXSd-0006De-Jq for pgsql-performance@arkaria.postgresql.org; Tue, 01 Aug 2017 13:43:47 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dcXQr-00005D-0m; Tue, 01 Aug 2017 13:41:57 +0000 Received: from mail-wr0-x232.google.com ([2a00:1450:400c:c0c::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dcXQo-0007Mz-Gx; Tue, 01 Aug 2017 13:41:55 +0000 Received: by mail-wr0-x232.google.com with SMTP id v105so7064020wrb.0; Tue, 01 Aug 2017 06:41:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=3KrrBnM/D/TeWJZcz5v4F1zUJM9Uz7QRv0H36KZBmI4=; b=OVrPGRgW5GzEu1TZVU0OGz6nCRVGZk38yezphziJ1upZsDhIdXCJKICrmpZ0l9E43n 5XwyiuX04sa2e8MVfvk+W7gIg/ZwfiMwneDSPFCtEkgh6bORCxFhIep+KfMPxdEzM9/i QYuGqRA0LrjBuUen7UhPpNOJmxQihk2ZoVHw3/BN8MARvEGmunXIKVQNbS9HqnvgmwsW +sYRg8lECO6z3C+06EF/rR8u1h2hJ8HEsBpBTzl/YuKwVn5fTvLLiOWSBlt8x1sGxm7o n3QYRebqipU8lJznA5uApxradj0MwkxEtEkUcYnIOB6zcQsrg9VVB7Z8Q9B4ChPg8cA5 MfdQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=3KrrBnM/D/TeWJZcz5v4F1zUJM9Uz7QRv0H36KZBmI4=; b=iRo6AvzSomW3XsAJUGWwanu+4Je2pmVzSk5eRsM8dAgH/pAKq0quDvjR+ryTnlbCCW O/UguQrPKKuotArGVo+emoFAUPRMH+qYVB/qQXnwUoh12TEdYgJCYgUEoNp3DRUVOF/6 OLYk8/4OHdw5QfukfkUm98XUgMtRmzpGA1Rl/8WLa6HjbzO5cSNVzdHh07gJR/DbnF6v iGCsDIad+5TDFq+R/VcodKCwH3fuUj5W1Dh1g1k9sUyuUBVO6bpj77wLMxFTy5g89Riw SCENLiZzlpdDLfUp6pqT5du/1+uPfJKCLcAUEmhrb1zz76SQtLkrluMa78d4ALKnp2Qb kqDA== X-Gm-Message-State: AIVw112AMRpsYn9urJdbwMC+lIXK1GtpKzeEwVwaMJVCILFJqC3VxUaZ 2wl30+klxK/AUMgygyeyoC2LgPq7d3BQ X-Received: by 10.223.128.47 with SMTP id 44mr13542656wrk.175.1501594912469; Tue, 01 Aug 2017 06:41:52 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.38.197 with HTTP; Tue, 1 Aug 2017 06:41:51 -0700 (PDT) From: Sumeet Shukla Date: Tue, 1 Aug 2017 19:11:51 +0530 Message-ID: Subject: 2 server with same configuration but huge difference in performance To: pgsql-admin , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary="94eb2c05a03c5ab8780555b14fca" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --94eb2c05a03c5ab8780555b14fca Content-Type: text/plain; charset="UTF-8" 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. Thanks & Regards, Sumeet Shukla --94eb2c05a03c5ab8780555b14fca Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
I have 2 PG servers with same h/w and c= onfiguration and they are not in replication.

On server A it takes 20 minutes to execute the scr= ipt.
On server= B it takes more than 20 hours. (Seems to be stuck with create index and an= d create foreign key steps)

Any guidance to troubleshoot this would be highly appreciated.<= /div>

Thanks & Regards,
Sumeet Shukla

--94eb2c05a03c5ab8780555b14fca--