Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcKsX-00GwyC-DH for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2025 08:53:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tcKsW-00AEZW-Cq for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2025 08:53:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcKsW-00AEZO-3C for pgsql-performance@lists.postgresql.org; Mon, 27 Jan 2025 08:53:56 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcKsT-001jS9-3D for pgsql-performance@postgresql.org; Mon, 27 Jan 2025 08:53:55 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-aaf6b1a5f2bso1066681066b.1 for ; Mon, 27 Jan 2025 00:53:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1737968033; x=1738572833; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=N9YVg9E2/5jn2mR9IzNv+/vEd0VXpETPP6p8PJ5RFhA=; b=rawKz59MowBvbAeBKPysIEGb5bnApHFsQ9s5HYq2zHIPLk7gbMVL0uczitPvygNM2y qYcMuUS5Qm50JGELJkkIpmVMe/RoHTYS+TV9yGnEvBIoel/cKhesScroPHCSTMaG7vqs Aa1aVFgUUqT/hmZTouYtFPnpIOn7F+RCLN9TEJRQ8Erat9GGscMYs/koNo5Pqfdf77yQ hio8/25cdzXpiMbdXm0P51U1h6/JYYO2u1zwT+3zIiUrgLH/CmUFjC7XEbgSvRRPPCMu yW5sVs6suszYxausjkICX1MnUw7RxMG/10/YFsqDdghmLqjs02xhGyg83+0/wdz4e9nv HdTA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737968033; x=1738572833; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=N9YVg9E2/5jn2mR9IzNv+/vEd0VXpETPP6p8PJ5RFhA=; b=NegXwkFqB80pr7FQhNalvluAAuyov8lNmml8/al3Ak0k9VwieCiQHwy8+RfHa3NkKz idEO4irrtZjHO7YwUwBxF2LvSUOi02W2/74o0JURSdohz2G6mLKKRhoCsqOfBVQliw9y tm6tjzP7ZQow8y13hq33R4cRYCLKNhv6wD3ksDVx1f8Vb4JjzT+iW6GMfnbgpggJbyVk YQzfJRGev4onFUNLUZ8qS9F82nEX2uvFOJ1gc4/T0v2KsRqoZab+NQG75F6aLNLPo2BW WSKszME5j67RqJa59DIXB3mj7hVKZxSBonpz31wS5y7YcIwQpnGr5oRwmWI1kDrBVV2Z p5Mw== X-Forwarded-Encrypted: i=1; AJvYcCVo6LIbussHAqk51+PNXqhVLCMwqy5vuOtZnA06YRIDdTuKJ6zsHLGYpcGKgK+1BxcGjyF1vNrxDsL0GSxssSqC7A==@postgresql.org X-Gm-Message-State: AOJu0YxIhbAAuVDgjV8Ay2aqTWVh/EPc/qUAM5a0xpypujGuDNiKd7Iv FLj16jryNeIZt/Kbfe+lFKhitcjtIAG51oR6aTJQuMso17irWdI+QPnQizqfryna2XJJfriQini l X-Gm-Gg: ASbGncukfxDX/iKCvVAZifafpvk5Q9YqSbdfFXjBgTxUVgAY17q4MYNzp9T2qE/ENoW cyA2Yl2x9YobF8nnIPV7T9nJbaVeiNUzxYSCJNfsuIzCezPGkIrLpTooFVmISBAJMDBvTvZaaw3 zk0VozEVXS66jL5Qcavmft+vbR/t2HxMhsWV7t/SPa8yWMd5Jc9nzQjjO/El3nflZGXY22zJWZB E8kfiaQCaduLHWLZiUoYNUeNAyy+y5o+IHuPqbhKbS/RpJiacNy8ycnFcoseeA7dHhy3VTkhnsn agwWaWddYvUqAgM/DoDs/KOZ X-Google-Smtp-Source: AGHT+IGDVXUXt+pWPiiGudZFQYHaBjfhxj2hXcypX+hbp14DDZmhcnzlhm9qg052FTtFwlmXeU+/rA== X-Received: by 2002:a17:907:3f25:b0:aab:ef03:6d46 with SMTP id a640c23a62f3a-ab662910bc7mr1473500666b.4.1737968033120; Mon, 27 Jan 2025 00:53:53 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:d10a:515c:df26:bd3e:3870]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ab675e126d3sm542382866b.7.2025.01.27.00.53.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 27 Jan 2025 00:53:52 -0800 (PST) Message-ID: <7c028373bf54624c5d1aa7f5a117d406c243b661.camel@cybertec.at> Subject: Re: Reg pg_restore taking more time in windows compare to linux From: Laurenz Albe To: Praveen Kumar Mandula , "pgsql-performance@postgresql.org" Date: Mon, 27 Jan 2025 09:53:52 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2025-01-26 at 07:14 +0000, Praveen Kumar Mandula wrote: > For one of our customer, when they are restoring DB, its taking more time= . > In Windows its taking around 43 hours, where as in Linux its taking aroun= d 3 hours. Check if the problem is caused by lame hardware. Other than that, activate pg_stat_statements and see which statements take more time on the windows machine. Investigating those statements could hel= p solve the mystery. Yours, Laurenz Albe