On Fri, Feb 26, 2016 at 5:30 AM, John R Pierce <pie...@hogranch.com> wrote:
> On 2/25/2016 8:26 PM, drum.lu...@gmail.com wrote: > > > I'm doing the pg_restore now in a 1.5TB file: > > *# ls -la* > > postgres postgres 1575324616939 Feb 20 13:55 devdb_0.sql > > But, the restore has gone over 1.6 TB > > > the dump file does not contain the indexes, just CREATE INDEX statements > Not to mention that on-disk format is quite different from the SQL dump. Due to row and page headers the on disk format could occupy more space, on the other hand if you have a lot of numeric data which can be represented compactly in the binary format, the restored database might occupy less space in the end. -- Alex
