tag:blogger.com,1999:blog-5541296000399974369.post7226111304649061325..comments2024-03-09T02:51:27.612-05:00Comments on Peter Eisentraut's Blog: Base backup compression optionsAnonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5541296000399974369.post-36580361571909396532012-05-30T11:09:37.167-04:002012-05-30T11:09:37.167-04:00Have a look at http://itwik.wordpress.com/2010/04/...Have a look at http://itwik.wordpress.com/2010/04/30/speeding-up-postgres-onlinebackup-compression/, I guess the basic principle would apply to pg_dump(all) aswell.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-27506508234802602242012-05-22T17:05:06.172-04:002012-05-22T17:05:06.172-04:00pigz is single threaded on decompression, unfortun...pigz is single threaded on decompression, unfortunately. lzop decompression is about twice as fast as gzip here. pbzip2 decompresses in parallel, but the speed isn't very impressive even on low compression levels. <br /><br />For very impressive compression/decompression speeds with moderate compression similar to lzop there's quicklz http://www.quicklz.com/ - Percona uses this for their Xtrabackup MySQL backup utility. It's even less standard than lzop and the tools are very primitive - but it's quite fast. :)Andrewhttps://www.blogger.com/profile/01066694104880792602noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-28630660117705352342012-05-21T06:04:50.354-04:002012-05-21T06:04:50.354-04:00try also
`pxz -3 --threads=$WANTEDCPU`
it is compa...try also<br />`pxz -3 --threads=$WANTEDCPU`<br />it is comparable to gzip in speed a sometimes compress bettervivohttps://www.blogger.com/profile/03399226698237306544noreply@blogger.com