POSTGRESQL 9.6 COPY created file bigger than the table -
im trying export oracle table local postgresql dump via copy command :
\copy (select * remote_oracle_table) /postgresql/table.dump binary;
the oracle table`s size 25g. howvere, copy command created 50g file. how possible ?
i'm capable of selecting remote oracle table because have oracle_fdw extension.
a few factors @ work here, including:
small numbers in
integer
,numeric
fields use more space in binary format text format;oracle stores table degree of compression, binary dump won't have.
you'll find if compress resulting dump it'll lot smaller.
Comments
Post a Comment