Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtoyY-00E4q7-Vv for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 12:51:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtoyW-001VPE-Hp for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Oct 2023 12:51:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtoyW-001VNm-8c for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 12:51:36 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qtoyS-001jIX-QL for pgsql-bugs@lists.postgresql.org; Fri, 20 Oct 2023 12:51:35 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-9ba1eb73c27so128106766b.3 for ; Fri, 20 Oct 2023 05:51:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1697806291; x=1698411091; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=7re97U14Yl+1T0jyyV3HCSi7JD9Nrk2meVPB2MFFqMc=; b=mInR1HmGTb+nIkF3oUMvwjBQKm82pKwsPNkrGNCtlJ2OuauUoNe+ZQTFkPcQEUggKS 3gJzET40FOzjc8WsfBQpUqM/QZvLIGw5xXKfzPtTZAsVq4XQHZ884JXcE0dLVaJ8HvqO 5JNkqvAoo/2nEmP7irTt+xns/Qs4kxYJ+Sz1Q5X8pBhUqY7fqrSQF3lg8B99PogdQFes 4stNpF0VzZc8o/GIwWQwTCDA6GpPNYCxy8tu4MdWbW5DfGRq/08JO3QbGoNsW4gvVnBK luvpIExPl6sYqo0zQ/f6vOP3r6eQ1tpv2nis6hIsHXiqxJmBIMMNxSdFM4535aNxmI3v 21FQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697806291; x=1698411091; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=7re97U14Yl+1T0jyyV3HCSi7JD9Nrk2meVPB2MFFqMc=; b=Yh1JvgOTbUgV+ktwQvHOtGBiTszFzU1X8tqTsFOUSGCI1OvMm9j1nVz/Ygk7hkZ9aJ BIM2Ea1vqfKU6nxldbp0tODTjDtUliLHSiKB4i32oy89AWmHBleRMAWBJby5huToos4x p5gZOjq0Cc12maVVRgwSYT3OuDQLhCzFZZGK/uCdi2o0OkwRYUUsbjLvG515voUq0lmm cbFD6SRUuFeNZjmbn8f1/Jg0JFHUDGAk6ogrCMr4ECNvKbhZX6Wr0h6HvymRojFp/2fh qBeT7AByfWeH3QX4Lw8lfhaDsQaHmjoFvCiV0CPCWTFXF9jn13bsHbmEGG7T0AiSTegI Ndbw== X-Gm-Message-State: AOJu0Yw8isC8gw7qdfngY8bH0Q3N+IrkinYfZhrHsQITLRpprXn+1uQE DKFhNzQPLiepcM/RnYrb9iqQQA== X-Google-Smtp-Source: AGHT+IH6+XjhRrrvNQZcqwBFh+oe5YuOdCi9PCUCEkMeKLqiiiUSTfw6MlvRBlajVGv+LKBIRie9YQ== X-Received: by 2002:a17:906:db09:b0:994:555a:e49f with SMTP id xj9-20020a170906db0900b00994555ae49fmr1131406ejb.31.1697806291643; Fri, 20 Oct 2023 05:51:31 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:e9d0:9516:cd08:a776:435d]) by smtp.gmail.com with ESMTPSA id c6-20020a170906528600b00997e99a662bsm1454408ejm.20.2023.10.20.05.51.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Oct 2023 05:51:31 -0700 (PDT) Message-ID: Subject: Re: slow pg_dump with bytea From: Laurenz Albe To: Janning Vygen , pgsql-bugs@lists.postgresql.org Date: Fri, 20 Oct 2023 14:51:30 +0200 In-Reply-To: <1c4abe5d-d6ca-4176-9692-2e95ce945438@kicktipp.de> References: <1325559b-6a40-411d-a1ab-1e1162e3722b@kicktipp.de> <1c4abe5d-d6ca-4176-9692-2e95ce945438@kicktipp.de> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-10-20 at 14:08 +0200, Janning Vygen wrote: > Anyhow, for me it seems odd that you can dump in a fraction of time=20 > compared to the default settings. With the solution in the link you have= =20 > both: speed and compression. Which seems to be offered by pg_dump -Z=20 > option too, acording to the level yu set. But it isn't. Who says that the only goal of pg_dump is speed? Like I said, specialized compression software is way better than PostgreSQL= 's built-in "pglz". Yours, Laurenz Albe