Обсуждение: Postgres vs Oracle

Поиск
Список
Период
Сортировка

Postgres vs Oracle

От
vinod kale
Дата:
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

Re: Postgres vs Oracle

От
legrand legrand
Дата:
Hello,
This will be very difficult to answer without additional informations ...
first index size on oracle, is bigger than table size, that
Could be sign of an over indexed table ...

1/ could you provide the indexes définition (index type,
Columns, Column type) from oracle

2/ same for pg

3/  informations about data distribution, like number of keys,
Number of Distinct values...

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html