Postgres Pro
Downloads
Home   >   mailing lists

Postgres vs Oracle - Mailing list pgsql-admin

From vinod kale
Subject Postgres vs Oracle
Date
Msg-id CAD7GeHRzv3tw266JB4wrmW46+5wzEWZAcsc82wuTz=2pLRGzuA@mail.gmail.com
Whole thread Raw
Responses Re: Postgres vs Oracle  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: Re: PG 11.8 > PG 12.3 : Unable to allocate section memory
Next
From: "JOIGNY Michael @Neteven"
Date:
Subject: Re: PG 11.8 > PG 12.3 : Unable to allocate section memory