Hello Monica,
Yes i have migrated after rebuilding indexes from oracle and also after restoration in postgres i have fired reindex again and also it reclaimed space in postgres but still the difference is major.
--
Thanks and Regards,
Vinod Kale
On Thu, 13 Aug 2020, 22:24 Mónica Gamarra, <monica.gamarra@xxxxxxxxx> wrote:
hello Vinod,I migrated a entire db from oracle to postgres and I had the same issue, tables and indexes are 1/3 to 2/3 bigger in size in general. I recommend you to rebuilded indexes in origin before the migration to make sure you are comparing clean objects, but I'm afraid this would not change much the result.good luckEl jue., 13 ago. 2020 a las 6:47, vinod kale (<vinod16895@xxxxxxxxx>) escribió: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--
