I have very large databases that are in postgresql (200Gbs+) and individual tables that take up as huge space. I know that in mysql one can compress individual tables with isam-compression. I understand that postgresql compresses text automatically, is there anyway to compress my large database further?
Isn't there any specific method to compress the tables?? or does postgres handle it on its own? cause I have a large nos of daily generated tables with footprint of each of the table to be quite big.. so i need to compress the individual tables.. please help.
Thanks and Regards,
Shabala Deshpande