Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcZCg-0002hY-LB for pgsql-admin@arkaria.postgresql.org; Tue, 01 Aug 2017 15:35:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dcZCg-00007I-4f for pgsql-admin@arkaria.postgresql.org; Tue, 01 Aug 2017 15:35:26 +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 1dcZCe-000056-Kn; Tue, 01 Aug 2017 15:35:24 +0000 Received: from mail-qk0-x235.google.com ([2607:f8b0:400d:c09::235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dcZCb-0001Ir-Tt; Tue, 01 Aug 2017 15:35:23 +0000 Received: by mail-qk0-x235.google.com with SMTP id z18so11202244qka.4; Tue, 01 Aug 2017 08:35:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=zZFK5lCAlNu42w02iBha5wrovNhV/0hNKsvO6c3/zZ4=; b=odfuul1zsC3byCu17vfc8egA5BJqZo4+WlRSr6QwXvKxInyUUXds8Pb+r9+cxiAU2r Fl/hPi3cy5Nq6FC+6qn7ZxoFsVhAcUB3c6wCBnyBP8mIED/skApGW6SWNGvohny/SCLc XIbFWo7b7hK9fhul4It4HoewGfzxj4DDSMK6GB7zxZGpARS8SMpcrC/032hAMg29NHgn bi6iAoxRohqgVg0nLNNN0OGwUeSQEj+jNP6ZYqjoZTtBogH8cPujpBXC00ll0JR/16Sw wge4xyPWQF3MsnSA/kk0k6c9GeiRG1et0+dKUUnG0Y2FMHLTSl4tCKm6L2H8CxYQ+8yo 7piA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=zZFK5lCAlNu42w02iBha5wrovNhV/0hNKsvO6c3/zZ4=; b=Ghf0xgfu5HNf9v4pjpyn17gd2Jeq4ELQZT+rQj9f+JPCyr5xTWaVqWWTJ/Bn9qfneV CShcFvB1tohCaJpmAJaebIPtVlMGH3lrUrC3SYVrrrEej93RoJJmqPcpWZrJ9tFcEpOc UCa8vJdTYv9PTJ1OWw6CLa5soow0ONCDU89dHcXOfEivkldQEA6v4Lh5DPaX9jRoh/JX JE3cR+/zP6iZQWCF4ttYAony1AsTlUfYT2Ud1bqZjl6xuW6YB1DMar4XtA9V6qQqXZA4 oD0P9QBxC+/O+GXWuOSTVlSTKaByFf2BfL+CVvXBrxKhH4eSX2uejXkqA3ladVMgkQY/ W9bQ== X-Gm-Message-State: AIVw110ozz8a/fZ9yA+Jc51SQuAtokssVoFWo+3By3cjM9PUBzOAZevj VAAFIU/VPnej91z7lF3bOU8DgTRR1A== X-Received: by 10.55.209.140 with SMTP id o12mr25246279qkl.68.1501601720689; Tue, 01 Aug 2017 08:35:20 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.104.11 with HTTP; Tue, 1 Aug 2017 08:35:20 -0700 (PDT) In-Reply-To: References: From: Scott Marlowe Date: Tue, 1 Aug 2017 08:35:20 -0700 Message-ID: Subject: Re: [PERFORM] 2 server with same configuration but huge difference in performance To: Sumeet Shukla Cc: pgsql-admin , "pgsql-performance@postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin