Postgres vs Oracle

From: vinod kale <vinod16895(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: vvkgadge56(at)gmail(dot)com, bsingh(at)aurus(dot)com
Subject: Postgres vs Oracle
Date: 2020-08-13 04:10:05
Message-ID: CAD7GeHRzv3tw266JB4wrmW46+5wzEWZAcsc82wuTz=2pLRGzuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Team,

Suppose i have one table in oracle 11g , with table size is 190 GB and
total indexes size present on that table is 203 GB.

Same table i have migrated by ora2pg and restored in postgres 10.11, and
checked it's size, then table size is 150 GB nd total indexes size of that
table is 350 GB in postgres.

So my concern is why this much of size difference in indexes in postgres vs
oracle.

Thanks in advanced !

--
Thanks and regards,
Vinod kale

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message JOIGNY Michael @Neteven 2020-08-13 06:34:18 Re: PG 11.8 > PG 12.3 : Unable to allocate section memory
Previous Message MichaelDBA 2020-08-12 15:56:08 Re: PG 11.8 > PG 12.3 : Unable to allocate section memory