Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p7Jv1-0002JY-6r for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Dec 2022 17:27:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p7Juz-0000Rx-3i for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Dec 2022 17:27:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p7Juy-0000Ro-RE for pgsql-hackers@lists.postgresql.org; Mon, 19 Dec 2022 17:27:12 +0000 Received: from mail-il1-x130.google.com ([2607:f8b0:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p7Juv-0008FX-U7 for pgsql-hackers@lists.postgresql.org; Mon, 19 Dec 2022 17:27:12 +0000 Received: by mail-il1-x130.google.com with SMTP id o8so5083335ilo.1 for ; Mon, 19 Dec 2022 09:27:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=XQK3vepovEKW5KVZ0sdboWNUor5rqSPFuy9hVVKuwDM=; b=ZbGBi2cCgHQ0hPTxWuV00oj2Jfb5U94wT8rPQ6uXLv1cV/Wa5PpQeZDNQS2n+FDg1e tvuzdzt4U6E42ZEjlADVjZSw1pkRpnHsXRvJ923GVbAe2R7YhOtuZpUSRleG8Cfdbjd8 OyXHE2gr4pmFyeNYAdaX6pGOwvf3Zz+rkAxebPLsimTx1fb3HwyFTKuGN0m7+vMyxqd2 eT9HHqobgu0SPyAU1zMO7PTkL/eUZ9gZll8jpSjL2mcbVusDXZF8P1BiUJGZnDQYXmt8 Qsp9rlfY5Qm/aM6UsT34v7YMyP9fhcBsw87J3l1+RwoFB7a5wIXw1Q6f3CnaslUFTbwG zg0w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=XQK3vepovEKW5KVZ0sdboWNUor5rqSPFuy9hVVKuwDM=; b=hqBIrmiMhRFlbRARnk/+mSSW1567ENcqjDzShhBD2Vz5bWr6djUdggOCgBKE7vfsVN Ce3WR955ajhPhnWrJIDLJ/NV7rY5KxYJvJW+MOz1xGZS5JQnu5gHBck8vbVmjyPdfr2N jDKk8SZ3+fEAEzqJXJ+wDkQTa19ka/z6RKPDAFKigjHgmSujwLI1ZcVjHS9gCbhGy2jq vtIY8a1NRf2UdtKNLA1J/UMP7JGRIdukvTsRgYeo3lCXtEf8Sm4udKywB9v6w5ksJTsO 3lZ/XKsxZgfKuG0wFhlpV2kskzrufEPL824hVHcZ+mQKsAXwkCciQItCQSHFsX4KaZj6 TQFg== X-Gm-Message-State: AFqh2koQiKi0GPpwSHsnOiY9/NtM3higINMwYG4ERy32Y6MRhiyav9UA jAtXaMM1fkbPe3bu3AC4rWwGYQ== X-Google-Smtp-Source: AMrXdXvAGg+wsXPcP7glwK+RY4vfFMW9y6iORcuLkkhQRygnNY1ok6M173P39zcLDazc9ZKAfVwT5A== X-Received: by 2002:a05:6e02:e0c:b0:309:1c59:dd31 with SMTP id a12-20020a056e020e0c00b003091c59dd31mr5031878ilk.9.1671470827933; Mon, 19 Dec 2022 09:27:07 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id k3-20020a926f03000000b00305e28bd099sm3416739ilc.35.2022.12.19.09.27.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 19 Dec 2022 09:27:07 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 5B11C8008DE; Mon, 19 Dec 2022 11:27:06 -0600 (CST) Date: Mon, 19 Dec 2022 11:27:06 -0600 From: Justin Pryzby To: gkokolatos@pm.me Cc: Michael Paquier , pgsql-hackers@lists.postgresql.org, Rachel Heaton Subject: Re: Add LZ4 compression in pg_dump Message-ID: <20221219172706.GA1153@telsasoft.com> References: <4wfmZ9BuGbkM6JXggut4g_gPl1hLbVeUwPEQh5nGgzlKCgnbtRaw7-nPcyPelGdG8ttH9A7vgyX_Z2fwZxuqHt1xENg9mqDfP_94qoZ5WxQ=@pm.me> <20221217232615.GS1153@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Dec 19, 2022 at 05:03:21PM +0000, gkokolatos@pm.me wrote: > > > 001 still doesn't compile on freebsd, and 002 doesn't compile on > > > windows. Have you checked test results from cirrusci on your private > > > github account ? > > There are still known gaps in 0002 and 0003, for example documentation, > and I have not been focusing too much on those. You are right, it is helpful > and kind to try to reduce the noise. The attached should have hopefully > tackled the ci errors. Yep. Are you using cirrusci under your github account ? > > FYI, I have re-added an entry to the CF app to get some automated > > coverage: > > https://commitfest.postgresql.org/41/3571/ > > Much obliged. Should I change the state to "ready for review" when post a > new version or should I leave that to the senior personnel? It's better to update it to reflect what you think its current status is. If you think it's ready for review. > > > 002 breaks "pg_dump -Fc -Z2" because (I think) AllocateCompressor() > > > doesn't store the passed-in compression_spec. > > I am afraid I have not been able to reproduce this error. I tried both > debian and freebsd after I addressed the compilation warnings. Which > error did you get? Is it still present in the attached? It's not that there's an error - it's that compression isn't working. $ ./tmp_install/usr/local/pgsql/bin/pg_dump -h /tmp -Z1 -Fp regression |wc -c 659956 $ ./tmp_install/usr/local/pgsql/bin/pg_dump -h /tmp -Z2 -Fp regression |wc -c 637192 $ ./tmp_install/usr/local/pgsql/bin/pg_dump -h /tmp -Z1 -Fc regression |wc -c 1954890 $ ./tmp_install/usr/local/pgsql/bin/pg_dump -h /tmp -Z2 -Fc regression |wc -c 1954890 -- Justin