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 1sRRFj-00FLyk-Ie for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jul 2024 06:56:35 +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 1sRRFi-002cym-9M for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jul 2024 06:56:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sRRFh-002cyd-RF for pgsql-hackers@lists.postgresql.org; Wed, 10 Jul 2024 06:56:33 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sRRFe-001KZl-51 for pgsql-hackers@postgresql.org; Wed, 10 Jul 2024 06:56:32 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-a77baa87743so642087566b.3 for ; Tue, 09 Jul 2024 23:56:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1720594588; x=1721199388; darn=postgresql.org; h=message-id:date:content-transfer-encoding:content-id:mime-version :comments:references:in-reply-to:subject:cc:to:from:from:to:cc :subject:date:message-id:reply-to; bh=nW/oE5eCkHxpgf2T4PdOg9G4qeEKp9dXWPuOuLRstkk=; b=zr9o0Hx6Qr+7j1a8DhRC8UUFKgktmo8z9L5zYtGnfxaAa5dVGrDktxO6NtPdXFP/84 a9QDCiRuc6dFD8O3jGrcwn60CVKHPI9/+TI9yTR4zWB58HN31aQHmYf9YxwlcocasxY4 dliZ5rQy7KCEQJR/IRjk7Y5dwo9dFUmLKMQAoMlgsHwq9QOIgnT23oTCDsfgGzElHEx2 uBCyuz2SHa4ZYKTeojQtEIH5D4e9mXbeLc7ugaRjV2Ib+tf12i4Tj0G3+mMMkl1EbCmb p20s+dPFMg/+oAQQL0f8pZ9r2GyXlRa57hTfW5w74GwpikNOuup0704fgWtzZfNAtGA+ 5JeA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720594588; x=1721199388; h=message-id:date:content-transfer-encoding:content-id:mime-version :comments:references:in-reply-to:subject:cc:to:from :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=nW/oE5eCkHxpgf2T4PdOg9G4qeEKp9dXWPuOuLRstkk=; b=YzjFHKcetMxePIkxMiJsA8gcJg7ZyZMvdjH4LmBEoxbiQB/Yke227kqexgH94TDmdn YmWb2lACqkuLwyOduns2gcUP2giKntv2KmO6K5JHf0OwTYFZ81aUy5t7n4wnG5IsRjx8 G7veC6vOu1kY54rHw1Im0QGaOwbBAnHFviX0UtR2Msv5G48K5tF4xlFoAYQOV2uOkX1c JqBx6pYhQbegkxlyBeFAoQ1KDN9cJjuyNHaUdsQw6H5Ems5n4O/AxHWKgqBU6ZSXd8eP JnSZJD+S5SQQar8E9sE33PIwZnh9I4N4FoS5HD4jQ9uo7PDC2BKVg64ZpQ0YMVWrc1uI 5V5g== X-Forwarded-Encrypted: i=1; AJvYcCWZJfTXL1UaQd43E1YrIyAzJNgEXrNNI8NTtpXLEpzZjWmOSiEAA5z4K2r9y9SA2eKbotThewhALCpbw5baxKSeULr3G0VOUF7gLyRO X-Gm-Message-State: AOJu0Yx5uuj68vccsoVM7y4bfQjZUGn8+Pa1IG7ehksusAHhRcCK9e1a tf2UBJc4WaqNpfw4arXqkMx7AqcM2dmqHhtdK6J4cPbN4KHyK7YvJ+sSJViHsoI= X-Google-Smtp-Source: AGHT+IE8qnifl6Tay7+tFwj5yT35RQe04dodB5fVbQN8q/Pem1Dpznh8hGAA36XtB/NX46fmhMhieQ== X-Received: by 2002:a17:906:d1c8:b0:a77:bfca:da53 with SMTP id a640c23a62f3a-a780b6b2f7bmr318420366b.30.1720594588295; Tue, 09 Jul 2024 23:56:28 -0700 (PDT) Received: from antos (109-81-174-87.rct.o2.cz. [109.81.174.87]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a780a8562a2sm132768266b.169.2024.07.09.23.56.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 09 Jul 2024 23:56:28 -0700 (PDT) From: Antonin Houska To: Alvaro Herrera cc: Pavel Stehule , Michael Paquier , PostgreSQL Hackers Subject: Re: why there is not VACUUM FULL CONCURRENTLY? In-reply-to: <202407091730.dhxwchklxhh6@alvherre.pgsql> References: <202407091730.dhxwchklxhh6@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Tue, 09 Jul 2024 19:30:48 +0200." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.2.50 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2667.1720594587.1@antos> Content-Transfer-Encoding: quoted-printable Date: Wed, 10 Jul 2024 08:56:27 +0200 Message-ID: <2668.1720594587@antos> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera wrote: > On 2024-Jul-09, Antonin Houska wrote: > = > > Alvaro Herrera wrote: > > = > > > > Is your plan to work on it soon or should I try to write a draft p= atch? (I > > > > assume this is for PG >=3D 18.) > > > = > > > I don't have plans for it, so if you have resources, please go for i= t. > > = > > The first version is attached. The actual feature is in 0003. 0004 is = probably > > not necessary now, but I haven't realized until I coded it. > = > Thank you, this is great. I'll be studying this during the next > commitfest. Thanks. I'll register it in the CF application. > BTW I can apply 0003 from this email perfectly fine, but you're right > that the archives don't show the file name. I suspect the > "Content-Disposition: inline" PLUS the Content-Type text/plain are what > cause the problem -- for instance, [1] doesn't have a problem and they > do have inline content disposition, but the content-type is not > text/plain. In any case, I encourage you not to send patches as > tarballs :-) > = > [1] https://postgr.es/m/32781.1714378236@antos You're right, "Content-Disposition" is the problem. I forgot that "attachm= ent" is better for patches and my email client (emacs+nmh) defaults to "inline". I'll pay attention next time. -- = Antonin Houska Web: https://www.cybertec-postgresql.com