Thread: Postgres vs Oracle
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
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