Last updated: February 19, 2025 at 03:32 AM
Summary of Reddit Comments for "database tar gz"
PostgreSQL Backup and Restore Options
- Running
[pg_dump](https://www.amazon.com/Roll-Up-Folding-Tactical-Drawstring-Magazine/dp/B07K89DPV3/ref=sr_1_1?dib=eyJ2IjoiMSJ9.hV_tog1krKxEIBPLXNF3HOTbf8Vb4i_gPaFUIKbNEJDZWsyiAF6exhNUa8mTabssya6GGGnoi0KpGqz4BXMiCw.o0S2qhwLMcAYG7KODhIsFSUCvFUkWYbQtih9dh88VBc&dib_tag=se&keywords=pg_dump&qid=1739935926&sr=8-1&tag=redditrevie08-20)
with gzip compression can tax CPU, especially at -9 compression level. - Using pg_backup to backup to a directory for multithreaded backups, compressing with
[pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20)
into a[tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20).gz
archive. - Directory backup allows for multithreaded backups and restores, crucial for RTO/PTO requirements.
- Consider using
--format=custom
instead of a directory for a single compressed file backup.
Compression Options for Database Backups
- Option 3 (
[[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20)
) provides the smallest file size, while.[tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20).[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)
offers even smaller compression. [7-zip](https://www.amazon.com/YaHoGa-Separating-Jacket-Zippers-Plastic/dp/B0[7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20)FZ1963/ref=sr_1_1?dib=eyJ2IjoiMSJ9.ZT7JAvKygL6sKSu1Jf3-MODkBSH_366OHvRewvLywFjJ-DznpTkVcueun5_1l1cYoPg7C4KoKpiAYe2cvTWUd0GnttqZs8F1ZpP_hBuqAsEnu0JKTAMeRD-IEJZq8_a22ecenWKq2ex8Lt1AI3J-mfQrX4Rplf2B1IqQpFUDdV-VKjuT6uWMPhG98R7MGUGx9vQqu1lMYehE_rg4X5zYHi4N-XBh-HUF7R_eJiG4bcGlL8s5asbLiu71qk-cu491t2mlGnv3Us5PuWOLWd64s_CxwaIcudWmH5PcncP4z58.oCzL1ohAR0-stNBX_fKPy3NJEA9NsW9JqQDuJp02i5Y&dib_tag=se&keywords=7-zip&qid=1739935935&sr=8-1&tag=redditrevie08-20)
offers better compression in solid mode, but may result in slower extraction times.zpaq
is recommended for long-term storage for its efficient compression.[tar](https://www.amazon.com/T%C3%A1r-4K-UHD-Blu-ray-Digital/dp/B0BGVYNJKP/ref=sr_1_1?dib=eyJ2IjoiMSJ9.R90aBnSB7IpufiIybjFd5sJtuq2pjaOqihK-zr8ZsMRwTffkZiRXq94kvG9Xf6dQRjHMNXtqKXk26ii-6WWkfQ-TVthQCg-Vg66D0y1qOBlCWqjS2UOrl1JigVDVppsgACQrYYfrwderX7XicsN0vLfPSxEN2oMGpzyFn_8G1bFWrDBM_6YOAsQqtLBaRkxnNHZtlq9FgjI6PxpP-gjb_hFUb8nP9N7wjNgBiXfHRKM.9N0aB-vBqelc-YzUrJk4p2f71s4heL7UtA0GbEIFbrM&dib_tag=se&keywords=tar&qid=1739935927&sr=8-1&tag=redditrevie08-20)
format is criticized for producing redundant data in headers compared to[7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20)
orzpaq
.
Considerations for Compression Algorithms
[[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20)
is recommended for unknown data types, while[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)
orgzip/[pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20)
are suitable for mixed versions like RHEL5.bzip2
is less efficient compared to[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)
,[[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)](https://www.amazon.com/JHSLXD-[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVoxE_Dfo0Pj2xMejl7UFVQyCiLgVA8KydOzlDoix07VefrmJiiW1LHlvwjdCo_DidoXhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.9FiXOC1RVMsXwfQUf3JzZUERpWRxns3uEgEnI_R3jFI&dib_tag=se&keywords=[zstd](https://www.amazon.com/JHSLXD-ZSTD-Ceramic-Restaurant-Decoration-Lampshade/dp/B082ZCQBB5/ref=sr_1_1?dib=eyJ2IjoiMSJ9.sy27tGSzfcQhyr4HghK1mZ82oTDyDcq3ePbGJg6oVozbFOEq5XVX559_Bbtmwdme6jDGE21z8XnNKYX1va0a-Y9e51R78-ZPz33SI32iK-jhoAoPSizDytbuBMwrNRFpnqRQEDHCfp5gxUFqM-Zeb40CYU1TBhXlaP1PVd8CipJMwGJNWIjBWJudnmYEwjF70f_8BBNVlLFC9Sl4qaozOf2X-Q1kSZJs6Ae4XInOduIFduKQd_L6bJq5AH2A2m8aNN23xjgn68VU7NdX1IDvn_YsR_o50_T0eEEv3ue6bpw.cgFGEtyZ_nF65ESgZ7uSNoFEpdwI6AmwCDKiP14awfE&dib_tag=se&keywords=zstd&qid=1739935926&sr=8-1&tag=redditrevie08-20)&qid=1739935926&sr=8-1&tag=redditrevie08-20)
, or[7z](https://www.amazon.com/Sure-Regular-Original-Anti-Perspirant-Deodorant/dp/B001E8E7GK/ref=sr_1_1?dib=eyJ2IjoiMSJ9.SXEOVekFzyGfHqYO0oFd9ApvHQgTBZR3Vw7NMq6zEodNhB4Rm5C-840rpscuWzrPpAbz1sYyxR9ZkKODUoOhI3noM7J6XnDlhar4FwfbAsjlj8jGdBsaOZ14r1ZbWQisz9ZurR-v4Qsa457Q31WsfUaKRJ0DSta-Blm0n3NCFvxXAE5cKT4E2hEh0VKanzNQmXXQ6TiXd8UiwA-Mv_Te4F-OR_ZhuTeFm2aZ7AO7DJ5VSl93bmx4xrwuPahmgllssbNEsvupgMo9dwplT9ydRWExj7LJ0pObuA6bqgEI6j8.o0MAoZZa_LDR6lX16vjDvirdVNG2GCLY9-XMZDvyn2U&dib_tag=se&keywords=7z&qid=1739935934&sr=8-1&tag=redditrevie08-20)ip
.- Test different algorithms to determine the best performance for the data.
Tools and Methods for Compression
- Use
pbzip2
andpi[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)
for multi-thread compression alternatives togzip
. brotli
is efficient but lacks thread support.lrzip
offers high compression rates but is slow.--[rsyncable](https://www.amazon.com/LANZYKU-Transmission-Control-Data-Right-angle13inches/dp/B0BWYNCSXQ/ref=sr_1_1?dib=eyJ2IjoiMSJ9.3Yyw3LglCIC174Kmvj9EUg.tJCTMMDrSwY3bDML7xbQ_b4EOax1yc0-R1CLFERcsqo&dib_tag=se&keywords=rsyncable&qid=1739935928&sr=8-1&tag=redditrevie08-20)
option ingzip
and[pigz](https://www.amazon.com/Manna-Pro-Farmhouse-Favorites-Flavored/dp/B0CQN3PC55/ref=sr_1_1?dib=eyJ2IjoiMSJ9.KlgoEr6GRzW7CDvhIEL_OTEjP63_cttbzIJbcz4tX4BpWKP7EVWUxkfHqPzAJhZhZJ9nWAgt0Ra3uizvnLMp0cmSHxWgF7BPqA2czpxV8UQ0Ce8kpNp_aJGYnWIs50C4t6cADQZNuVFIEgwEpxBl0KHcPgHixX8[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)tu7X30fAIuKwN4TvYnvViMHYsQPPdXgo2RIHQh9o6HIDn7O6D54bj34dECR44R-T_5201GKSgnzKjzLsaPa9x4HpuWcnsd8lYEiT2B369EMUENZHI9oe6ebcLE6CjEU-yZc9k4doU0.tELc7gDR1XkOdhbzwxJdDN_FK6sSbqIekvuYvmOWNJI&dib_tag=se&keywords=pigz&qid=1739935929&sr=8-1&tag=redditrevie08-20)
aids in efficient file transfer.p[xz](https://www.amazon.com/Breathable-Durable-Sleepers-Pillowcases-Natural/dp/B09KXLMB33/ref=sr_1_1?dib=eyJ2IjoiMSJ9.cdqqn9D3azogU_wdw4V8OSZ-VR8ERLILC5_piYOtOVdHZEN7uxVgcTxhmmEgGKmd-mw7n1tbtKBvHKbO9ek-19KUTPXbFbxHJvkemaMkeFP96gHLKhso_T_nuOGpT7qo5xLSntynmCOqwuzv7Kz0aXmstKzJBGjFk4TtOu6OoTf4j4nD8DVv-fZOjqsbJLuKaE4kIKhOOETDUgGSb67BBTuLG5F4W3xiswBuxSaGwh2LcT3M2T5I-woz5mtn0bzIZjt2zOmnv-oYZdGmLRtdO9oa9ikgDcRuZp7ikbCSUj4.0LkP1Ob3dzRp_Cut5fRDTgnPnsK65meTsEOjJvc2Xzg&dib_tag=se&keywords=xz&qid=1739935931&sr=8-1&tag=redditrevie08-20)
and[lz4](https://www.amazon.com/1PZ-Quadsport-2003-2007-1998-2002-2000-2001/dp/B07GDD4XMD/ref=sr_1_1?dib=eyJ2IjoiMSJ9.pbHRMtFMijIE6St42ju_U0zkm5n1lZ89pUWZXOjuS4vT1xummXr9d66Sq0LG8mcnLq-6k7u0HUxq8bxcEH02Y3wQYFgSMO-sIYV1q3irTlxHGWseMXaGvk5DZbyCuPbV0caEPK5-wWZ91Di6bpbJ4gMa07ipEPSWFU3ehNy3dQyaZrNrO26ZH-mMI_EHUCMamm0yRrtUSX95b5EqnWMuUsZVMnQv2dxrzU54ahTIUBxpVFwlLhoQv3JEvFv-pedXyJrd_D9foGmX1PPHd5MCu8ZKcQyYSH3kl-qC_7j73Yk.AwJOLi0mC-I0dUpjxKghqZ_i_c34WawM3MttnlMG3gE&dib_tag=se&keywords=lz4&qid=1739935927&sr=8-1&tag=redditrevie08-20)
are recommended for various compression purposes.
Other Discussions Related to Compression
- Using specific LZ implementations for data compression on different platforms.
- LZ compression replaces repeating data with placeholders for efficient data storage.
- Compression may not impact performance significantly, especially with
[lz4](https://www.amazon.com/1PZ-Quadsport-2003-2007-1998-2002-2000-2001/dp/B07GDD4XMD/ref=sr_1_1?dib=eyJ2IjoiMSJ9.pbHRMtFMijIE6St42ju_U0zkm5n1lZ89pUWZXOjuS4vT1xummXr9d66Sq0LG8mcnLq-6k7u0HUxq8bxcEH02Y3wQYFgSMO-sIYV1q3irTlxHGWseMXaGvk5DZbyCuPbV0caEPK5-wWZ91Di6bpbJ4gMa07ipEPSWFU3ehNy3dQyaZrNrO26ZH-mMI_EHUCMamm0yRrtUSX95b5EqnWMuUsZVMnQv2dxrzU54ahTIUBxpVFwlLhoQv3JEvFv-pedXyJrd_D9foGmX1PPHd5MCu8ZKcQyYSH3kl-qC_7j73Yk.AwJOLi0mC-I0dUpjxKghqZ_i_c34WawM3MttnlMG3gE&dib_tag=se&keywords=lz4&qid=1739935927&sr=8-1&tag=redditrevie08-20)
on Linux. - Consider load times and performance impact when compressing large files.
- Validate results before and after compression to ensure effective space savings.
This summary provides insights on different compression methods, tools, and considerations for database backups and file compression based on Reddit comments related to the query "database tar gz."