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.98.2) (envelope-from ) id 1xEl4O-00000001GQx-2EQN for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 10:09:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xEl4N-0000000BT5h-2EhN for pgsql-general@arkaria.postgresql.org; Thu, 08 Oct 2026 10:09:47 +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.98.2) (envelope-from ) id 1xEl4N-0000000BT5Y-0uDb for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 10:09:47 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xEl4L-000000012Xg-04ci for pgsql-general@lists.postgresql.org; Thu, 08 Oct 2026 10:09:46 +0000 Received: by mail-ed1-x535.google.com with SMTP id 4fb4d7f45d1cf-6acbaec0d70so126262a12.3 for ; Thu, 08 Oct 2026 03:09:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1791454184; x=1792058984; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:content-type:from:to:cc :subject:date:message-id:reply-to:content-type; bh=iyPJJR/YAGr4XKBe/m9kX1WJMBOLxJHA4QucSVlj7Rc=; b=OHuQXTtRNdBdi8frV53pPqjYHYBn/YsU4BZbwz/rtt/ylXJIek8YLA3NiSbacngCBr MPBurOe9kRA7xGxRPIerRKPvNaplKKniHSRdh3lp0TZujaQreZvwv7QGy7cyOrG51tkM ddyzbwazTv8WtPC1lVfThlZbH2sJgh94LyiPTCtRVqjFHt2ZviEP5lPhYBKEStqaxjRO 4EwVzgX7Ba/Ll0HrSCA1e6mqdoZ27/x4i+FU4A8R/5+W6jOzdtDuxSjLChd1kHA9AJZx +1II6BmkxvAXv3F+OwaJqF3dGqu93glF9nqZjjfvQ/+W2UwUhFa67QteB3jCD9nNc8Fk kOLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791454184; x=1792058984; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:content-type:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=iyPJJR/YAGr4XKBe/m9kX1WJMBOLxJHA4QucSVlj7Rc=; b=tbFPLBLqfstJ/LluoAfzuSjQUlm/xA2ZiuxNJSHOEW9U+18aa28ZKEtR9h4TuD7Vku MRTGzWxwizZQJnXG7kzSXmfi3FipZhAmW/ijc8fWYz8Q/ucgEFvqMUsZQlVB1jrm2enG P+XLQwc9ZGjryYjK2nHOqPTN1zI9V1GrZRCplBPnp0K3iGRIBV/PTHXNEJ5NQj1ZUWYs BoQgXLmLKmRNwuSgFS8Bhz1YHBLg+CNc68C9vC7q1qKWY4tsFhi27V4v3YXmI0+cFvSm scECjLYliplstLpbAdQ3XfVgN9wff4waIJ6hoHLnRubWjbzlu5fCkpbyiy9uatDZaxUV 8tgQ== X-Gm-Message-State: AFq9FYLeA9yH9qOjIhj2QNR5FSyOIJo4b7yHjB02VlbiT9wLonp8p9bY 7XTTnKal9T989tUzyXdtJIgDj7noo67Dm4GI9xkzcYz/juHa9rHqOV2r X-Gm-Gg: AYBFou0veF4Nv5WlW8B2Jh770IFP2W7Fi8Slg+WzYjCAiC7zxCyXZfWqllRtpn1eQYC fBAoT3VkuXUkFIqJ/kQ73kX4djE7iSNtMAi6x8AH7vgnGxDcazcVKxgJcIt6ugBpBYoWlWkFBRP hoY0tHVzF/1P5OZc7Gq/lFMZKBxpJULw4czx0bHXUaEj1jejAh8PQpA7KduFvY2CrIjwI2QZklx U3eKiQBTSjvGmk1/PQJ5MaJPAlpXfN3XnHZTcXQL1jE3C2HJmGM54gVxhvxPDh7IydH2XJQcSNm SX7JJlusVFOcRpotrjiDwWyIz3fxf5FFg3rOutKH2xRwaNlL7GgBiAAEEQNbDS5TZyI0py8ts0C K9hZBIBnB7B23uXfqdKTK2Jfg/RHKsI3NARghYTAwevbeDBNFKSOAW2+Aden5Y8yFU/DOIvZvI0 cyICWjeinqx5qgzKg9wrn+WwA2Zzdh4fJe9gK0t3G6HF+nxmLPFd+bRwB3HnODqCQx0FQp3zis1 v7e69At8AslJ38eTqabV+pLLs8tYA== X-Received: by 2002:a05:6402:449a:b0:6af:9b71:ded7 with SMTP id 4fb4d7f45d1cf-6b0101e26dfmr2337172a12.0.1791454183819; Thu, 08 Oct 2026 03:09:43 -0700 (PDT) Received: from smtpclient.apple ([188.212.112.125]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-6b00aa491a5sm1116017a12.34.2026.10.08.03.09.41 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 08 Oct 2026 03:09:42 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3901.100.1.1.12\)) Subject: Re: Challenges with huge postgresql deployments in 300+ TBs From: Alban Hertroys In-Reply-To: Date: Thu, 8 Oct 2026 12:09:31 +0200 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: kavya chandren X-Mailer: Apple Mail (2.3901.100.1.1.12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 8 Oct 2026, at 09:05, kavya chandren = wrote: (=E2=80=A6) > 6. Finding equivalents of oracle items (which is common during any = oracle to postgres migration) There are a number of key differences between Oracle and Postgres that = I=E2=80=99m aware of. This is by no means an exhaustive list, nor may it = still be very accurate today; The last version of Oracle I worked with = was Oracle 12i, so things may have changed. - Oracle doesn=E2=80=99t (did not?) differentiate between '' and NULL, = while Postgres does. Make sure you get the right values in the right = places. Safest bet is probably to import your data using column types in = PG that allow for '=E2=80=99-values, so that you don=E2=80=99t get = interrupted by errors from NOT NULL constraints and the like, and fix = those later. That=E2=80=99s probably less of a hassle (even with 300+TB) = than trying to correct the data beforehand. - Oracle has CLOBs, where you can dump those values in a (type) text = field in PG. That may introduce a character encoding though, on which = some values could fail if you don=E2=80=99t take care of those = beforehand. - Oracle has BLOBs, where PG has a separate LOB table or bytea fields. = Either approach has its cons and pros. - Old Oracle DDL may still contain CONNECT BY PRIOR recursion. PG uses = recursive CTE=E2=80=99s. - Space-padded strings (CHAR(n)) in Postgres are supported, but they are = usually advised against. Both performance and practical use of = VARCHAR(n) are much better, with no practical benefits for CHAR(n). That = is, apart from formatting monospace text output without processing = (console style output or matrix printers and the like). Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest.