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.96) (envelope-from ) id 1vPy6k-003jhX-32 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Dec 2025 07:14:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vPy6j-000tWq-0c for pgsql-admin@arkaria.postgresql.org; Mon, 01 Dec 2025 07:14:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vPy6i-000tWi-2Y for pgsql-admin@lists.postgresql.org; Mon, 01 Dec 2025 07:14:01 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vPy6h-002Ss5-0U for pgsql-admin@lists.postgresql.org; Mon, 01 Dec 2025 07:14:00 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-b736ffc531fso606743766b.1 for ; Sun, 30 Nov 2025 23:13:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1764573237; x=1765178037; darn=lists.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=byE9SOnZ3EotGWiNirmgql98cwnHdWSJHOTbNooQgWc=; b=V4ofJnxbtYRVf7RSGNXnPwujTd1m3yf3pAtmcqhrfubhaigvFH5hudoez/OLaSeK3f +6+rxywdyjccQmaC9BB5LY4orw+X8llqnBwhOeoCeFwiskznYumyfL9/wThAHd8JQVj/ AxrXTWfEazhbheYkSQfRs4cjRHZoa+5y0Ngbj3H68ddEuIyt1FxAwErXDJKyEIK8Ylrf zl4+DA++a+04T8oTf9BDurOShDUdh3B8AP+Ihgob9QiyDzA0cUrY/onKm//VWGP8RXOx IcD278dN7GQg4pLKmUzNGatCXSoPqyqrdVswGKdAHB/7VqRPfxdCQ0Xwt7uVFWGI4N3n fp5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764573237; x=1765178037; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=byE9SOnZ3EotGWiNirmgql98cwnHdWSJHOTbNooQgWc=; b=mgvlU+MQUGlg1yY34ZXssjN9MxsKftphZNoF7VORauqYa4KQUDv3Nyer8RUjE3+P+F 9WRzyeI2IUzFPdMJjteqy4VreqJ/9gwi+29avT+jyNxZpQovKsMl05kKWAdi0tSAuM0m Sx/8LuFqcWmVZLGzyaVZzchNpK7E4Ln0ppUSEwcL3qfFGspNskb16/8DQeXh6plFuRof GCl0ho3ekgUppiBpJ3mZe703K5kd6D+zSDs59XSlGWC+yTD0o68n7hOjMywkt14t+RMQ q/4WV1lWDI+gRcwaBWjElVJqF7RwQYuCFLX+YH3xPDVXhIpWc0pBg6I+cJ8ldF1JdCyS KADQ== X-Forwarded-Encrypted: i=1; AJvYcCX5ZCGBOIVlHUMJ53Xp+X5z10nAzscFNz4T7X5wx2dpK/ECKgim3uwpJ46viurpyzSagjRo3GKnKPxhJg==@lists.postgresql.org X-Gm-Message-State: AOJu0Yz9LMifpW/kdL/Y9TbYYU/eaF9OwR1dMvwsg8eWNa++j0r00fR+ UZk7UXmloBuefUwpfhj2m7GdJ5UJ7AltqD+2BR7F4VD9SQ0XSwJ3myIOGg7+wqt4afo= X-Gm-Gg: ASbGncuTrp/OfLdk92XllzCJMV8WEx/nFl5T1dAIwhQPSCQpp4nyUf6lbU1QvcLPA11 jtBnpmiiRn1VoeHx9TviHjazNemEZ5QhkpiGGKB/CdxEgbkEC9Va9XNvfwQUoPO/zNZgnfKz82I g0BvP1KUZjp7Z/qxHyuxMqA4eEG0RubAZaWaU5BYOytxWL/4J/Pma8rv225iPR58PoRyJWjOpNa R9H1I8WW1b0CEJLDKKpgxBiC32FDknh0yQs3iIi+RCd5G8AAi+igHCspTZf8+c+4zW7VRkKugkf q0ouyl54UwG0xIYNMCddvH2auJ3InZy3uNYrlpDUXX1WuopSZpraSgixS9LRhNC43dbk8EdVyqa CpqJGXjpSfodQw1knAagsYfnTFbOR/QbAArgwitbI5FNspQogtxg/b3J+zWaSVDD8JPA2OeuH5S 7SfRBlLZi3dRZ5nWONpoAS74myYfkVBrZ5wF8CmuqD X-Google-Smtp-Source: AGHT+IEp0cQCBl6clf1ZjYXz+VSEMd5LICueBqCafUW9/zLXV99mEliSQm/9vVjkge+SNGI5Viuu8A== X-Received: by 2002:a17:907:961f:b0:b76:25fd:6c26 with SMTP id a640c23a62f3a-b767150bcb6mr4157888266b.6.1764573236663; Sun, 30 Nov 2025 23:13:56 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:1ce:374:d99c:26de:53b0]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b76f5a7afb4sm1127720166b.70.2025.11.30.23.13.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 30 Nov 2025 23:13:56 -0800 (PST) Message-ID: <8db363787dc505e0dbe01ab48c437205928f1c2b.camel@cybertec.at> Subject: Re: Migration from MSSQL to POSTGRESQL From: Laurenz Albe To: Raj , Pgsql-admin Date: Mon, 01 Dec 2025 08:13:55 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-12-01 at 08:46 +0530, Raj wrote: > I am migrating from MSSQL to POSTGRESQL. In MSSQL, I am using 64 vCPU and= 250GB RAM. > Now how much we can give in postgres? If these specifications worked for you with Microsoft SQL Server, use the s= ame with PostgreSQL. If you can, don't use Windows. Yours, Laurenz Albe