Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m5R4r-0007Ya-0P for pgsql-performance@arkaria.postgresql.org; Mon, 19 Jul 2021 11:04:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m5R4q-0003R3-1R for pgsql-performance@arkaria.postgresql.org; Mon, 19 Jul 2021 11:04:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m5R4p-0003Ql-Pn for pgsql-performance@lists.postgresql.org; Mon, 19 Jul 2021 11:04:47 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m5R4f-00072H-E7 for pgsql-performance@postgresql.org; Mon, 19 Jul 2021 11:04:47 +0000 Received: by mail-wm1-x334.google.com with SMTP id f190so8524445wmf.4 for ; Mon, 19 Jul 2021 04:04:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=dW4WwXJmc9y9vGSO+dOkvIgWdggc25Jteg8xk4YR89o=; b=rgomOop4kz8buEsSMKF63qNu0vnAXYueEB3Knt4ViyWOQ74loUD29It/zgNfTkdti9 QQiD+YyUVnuj+kNrM91oyR7/9g6mTIA7htQpK0Aq+JluZ18ZWMN/N7PN+5VeKgQOV9B8 DmVAfctlmy/MCJZJkocsgd15a3rNc+I0cFWFbEM4ZbWduVvQDYyLFhbLRUUwgWtB4WbI 8qQpABkWeuUUe7DtMQFGaEd7Zd7sEMjGJsfWhYoh1TmEcI5I9SRpoTfFt/RiyaBihZfx fHrYNoOlzYTTJZmhgHyttRdH6AG5GvqZdgJrtv3YNsID4cd3A3S9WelclkbYAN9okmNb Wf6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=dW4WwXJmc9y9vGSO+dOkvIgWdggc25Jteg8xk4YR89o=; b=VzKB11u8jhtdsv7L1D3SXFW8PomFdBtL3R4kc/bYvX/v1lUbkfbUGXLAnUnlHlKW7n A5CNiIY/g0Nqoj3sGgwbgTTGEhEuoxylinbQE8RzaFUScwtYUxWvUT99HRtL64V+S5zM OajaVKeCjOEh3/zgN8DG9+KtTziVkkfDgHnEHdCSGcXm6yTZh21k2ZhS9lSnbp1acshe GIDnQ2LqCoJQqKaPIHVTCldTkmqaPY1IgvxGoOm1D5sfpLbDtgy8mf/e4ulNVTiVOBvU Tu2Z0sQHgbSmAxx/IwhijZn6tZRrshNmXO1BnQ6i2b0vZpPX6CkB9WBUzJefD2XlC00g 6rUQ== X-Gm-Message-State: AOAM532LxlVtAVTr0YGgK6gVVpV1ExjTiuzNVuD+JRVbyd7jnvvYg4YX IXrtQyW+8hkuQEca/8MRPMPAkQ== X-Google-Smtp-Source: ABdhPJy4JadGTyC7RZHUCWahyZZOLquy4ve703c1Y5dGOx3TVvCWqWDc5/9mBee9tuzmxhqUSq8VaA== X-Received: by 2002:a1c:f314:: with SMTP id q20mr31788949wmq.154.1626692676285; Mon, 19 Jul 2021 04:04:36 -0700 (PDT) Received: from localhost.localdomain (217-149-171-226.nat.highway.telekom.at. [217.149.171.226]) by smtp.gmail.com with ESMTPSA id d18sm15639942wmp.46.2021.07.19.04.04.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 19 Jul 2021 04:04:35 -0700 (PDT) Message-ID: Subject: Re: Performance benchmark of PG From: Laurenz Albe To: Manish Lad , Pgsql-performance Date: Mon, 19 Jul 2021 13:04:35 +0200 In-Reply-To: References: <836265572.4593017.1624590607279.ref@mail.yahoo.com> <836265572.4593017.1624590607279@mail.yahoo.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2021-07-19 at 15:39 +0530, Manish Lad wrote: > We are planning to migrate Oracle exadata database to postgresql and db size ranges from 1 tb to 60 TB. > > Will the PG support this with the performance matching to that of exadata applince? > If anyone could point me in the right direction where i xan get the benchmarking done > for these two databases either on prime or any cloud would be great. You won't find any trustworthy benchmarks anywhere, because Oracle expressedly forbids publishing of benchmark results in its license, unless Oracle has given its permission. The question cannot be answered, because performance depends on your workload, configuration, software and hardware. Perhaps PostgreSQL will be faster, perhaps not. Test and see. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com