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