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 1tcQh0-0001mN-KD for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2025 15:06:27 +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 1tcQgz-00D2aY-Il for pgsql-performance@arkaria.postgresql.org; Mon, 27 Jan 2025 15:06:25 +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 1tcQgz-00D2aQ-8f for pgsql-performance@lists.postgresql.org; Mon, 27 Jan 2025 15:06:25 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcQgx-001mWk-0W for pgsql-performance@postgresql.org; Mon, 27 Jan 2025 15:06:24 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-5dc10fe4e62so8414536a12.1 for ; Mon, 27 Jan 2025 07:06:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1737990382; x=1738595182; 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=dRVzzomhhLq1kHwpxmTPXN4xNP8w5EjFZgA/KDpdx8Q=; b=PmsEeeowrUQ9Wfxd2t7SqXAFTOKxeDArs/DP1ccMaV4bMuERTJMtgBH7vWoPejR66d tioaSluaM+QFY6tXXKTzdxwBK47DRElvFUSp5N5j60PX1+hYZSu3Ab/XemXJEEbH53l6 2Zp3CVAAOd0pJJT7QGFhbNcsgZ50+BN/7FkTpgDfBGG2kPJLoZISshpg6ZEhQlpftALs o0VT1AlWlPdzXvvJCSqyQgDaJENEznyC1IFG4082cdunIVZ5V4o74D1hBZIQbdN1k9R/ MLmLrPxkZtPH4tkZlxLB3ODOAMmGGtEOzrOZAWqol/EwRJbzGOikzRJGuSMiSvbmzN3j ieGg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737990382; x=1738595182; 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=dRVzzomhhLq1kHwpxmTPXN4xNP8w5EjFZgA/KDpdx8Q=; b=Q+kTa8H0w41PykHI953+H1sfs5V5/OyZWWxPS7d0Ftv8YwEpS+twepo7MgIb9M9KcL DfwK+qVVp5FfRTzwZB4cspxq9xbYgce4yN6FlEdEqdLfDxiRe9yQu3QymhPwgBLmIH4m gyplndMbvNrzncYoujW8oZoSFLb61Srfk/ly2bMSy+Vk/7eB37fHRWVAQj0B8+j4MATT zMwNjEEtlQLNYNgtFk93iWCPyBVgnZFuYqzvHJYvWb61mJ33rKZ7dRNUMi1dYzpM5dK6 Jr1VeK/Jl1qZY1tdqWz8XacpIsdiwA4jPFs+Dih4Xgw1CTuKQaNWCfY/A/GvP8vAI5uQ r5SA== X-Forwarded-Encrypted: i=1; AJvYcCUioaoYBoNdY4zsGUQVCtupvWxG2CjCvazbxw9YI6K5Q//I1edpjYnhWkVUEGRtz2IgyrqwDTgo3n3kJCXw+AX7YQ==@postgresql.org X-Gm-Message-State: AOJu0YyQyY3wzNrfDjz3hgwxx/Sh3yPF6NnGFrgqglo07Vn6+2QVaqiU +B653oHfxsgJ83+hVuYpIJraxSN0I8SOgfXivY5qJ6gDCCX31yg6WPJDWw+fr9GhA6z4NPjTv4X 3 X-Gm-Gg: ASbGnct0bUo2SQaqVmi7EziYlN2VrXlcl39xFgUsLqiDsVlWbwifjMUJ9m7DrLzhx6R LJUZVuHXKmN/V3UvbXRXqRKtLq15gQd5r5iui8yOVCX/RUrKMzCWrzkss4VH7+lEFM7r7BQCqni dzF0JmrVELV8VcOSI5SrQUMRnaw1pDPANNVgsRlC2gLYDiNZLrF9qKLD1egMFpjf5nDiqjp1dH8 WR7K7p3QMEh2YHDWNPIdalz0+ASZcCtwC6N/M+sp2xcE3UHOeF155jJyAr5wAecTu0fCTXXEwQW FMaEzaSmuvBMVMYBy8sEpeCs X-Google-Smtp-Source: AGHT+IGhBuZrYSn2b8EfYDP2h+MAh3/dKDdu2E01b/X1eo1GaRRaynNFaAMKFaR2AxfL5cIfcRNpig== X-Received: by 2002:a05:6402:3494:b0:5d0:b455:36ad with SMTP id 4fb4d7f45d1cf-5db7db0786bmr39737909a12.27.1737990382097; Mon, 27 Jan 2025 07:06:22 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:d10a:515c:df26:bd3e:3870]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5dc186d8b2csm5472190a12.76.2025.01.27.07.06.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 27 Jan 2025 07:06:21 -0800 (PST) Message-ID: <55c7c6494f40763faf10c3dccbbe7d357aab58f1.camel@cybertec.at> Subject: Re: [EXTERNAL] - 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 16:06:21 +0100 In-Reply-To: References: <7c028373bf54624c5d1aa7f5a117d406c243b661.camel@cybertec.at> 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 Mon, 2025-01-27 at 12:29 +0000, Praveen Kumar Mandula wrote: > Attaching linux and windows logs, are they useful in identifying why its = taking time more in windows ? No. I told you what to investigate, right? Yours, Laurenz Albe