| From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
|---|---|
| To: | Jeevan Ladhe <jeevanladhe(dot)os(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi(dot)shinoda(at)hpe(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Dipesh Pandit <dipesh(dot)pandit(at)gmail(dot)com>, Abhijit Menon-Sen <ams(at)toroid(dot)org>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Jeevan Ladhe <jeevan(dot)ladhe(at)enterprisedb(dot)com>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: refactoring basebackup.c |
| Date: | 2022-02-15 16:54:48 |
| Message-ID: | 6a2e3bf5-100c-8730-c49b-29932eef7d0e@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2/15/22 6:48 PM, Jeevan Ladhe wrote:
> Please find the attached updated version of patch for ZSTD server side
Thanks, Jeevan, I again tested with the attached patch, and as mentioned
the crash is fixed now.
also, I tested with different labels with gzip V/s zstd against data
directory size which is 29GB and found these results
====
./pg_basebackup -t server:/tmp/<directory>
--compress=server-zstd:<label> -Xnone -n -N --no-estimate-size -v
--compress=server-zstd:1 = compress directory size is 1.3GB
--compress=server-zstd:4 = compress directory size is 1.3GB
--compress=server-zstd:7 = compress directory size is 1.2GB
--compress=server-zstd:12 = compress directory size is 1.2GB
====
===
./pg_basebackup -t server:/tmp/<directooy>
--compress=server-gzip:<label> -Xnone -n -N --no-estimate-size -v
--compress=server-gzip:1 = compress directory size is 1.8GB
--compress=server-gzip:4 = compress directory size is 1.6GB
--compress=server-gzip:9 = compress directory size is 1.6GB
===
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2022-02-15 16:58:56 | Re: Replication slot drop message is sent after pgstats shutdown. |
| Previous Message | Andres Freund | 2022-02-15 16:28:09 | Re: Fix overflow in DecodeInterval |