Re: Postgres vs Oracle

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(dot)gamarra(at)gmail(dot)com> 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 luck
>
> El jue., 13 ago. 2020 a las 6:47, vinod kale (<vinod16895(at)gmail(dot)com>)
> 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
>>
>
>
> --
>
>
> *............................................Mónica Gamarra
> Barriosmonica(dot)gamarra(at)gmail(dot)com <monica(dot)gamarra(at)gmail(dot)com>*
>