search

EndPointCorp / end-point-blog

End Point Dev blog
https://www.endpointdev.com/blog/
17 stars 65 forks source link

Comments for Postgres SQL Backup Gzip Shrinkage, aka DON'T PANIC!!! #250

Open phinjensen opened 6 years ago

phinjensen commented 6 years ago

Comments for https://www.endpointdev.com/blog/2010/01/postgres-sql-backup-gzip-shrinkage-aka/ By David Christensen

To enter a comment:

  1. Log in to GitHub
  2. Leave a comment on this issue.
phinjensen commented 6 years ago 
original author: Jon Jensen
date: 2010-01-09T22:06:17-05:00

Fascinating. I'm confident I would've been stumped in exactly the same way you were.

I wonder if bzip2 and xz exhibit the same behavior.

phinjensen commented 6 years ago 
original author: Andrew
date: 2010-01-10T10:41:48-05:00

I almost always use custom format dumps (for use with parallel restore if for no other reason). But the good news is that data members in custom format dumps are compressed with zlib too, and so they should benefit from the same effect.

phinjensen commented 6 years ago 
original author: filiprem
date: 2010-01-10T12:34:59-05:00

Tested on table with 1E6 integers - sorted and random: both "custom format" and bzip2'ed dumps have this effect. For gzipped and -Fc dumps, ratio is 3/2; for bz2, ratio is 5/2.

phinjensen commented 6 years ago 
original author: Storagecraft
date: 2010-01-14T08:35:18-05:00

Charming!!!! I'm sure I would have been confused in just the same way you were. But I think that this is a good procedure to go for the backup.