Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\))
Subject: Re: new heapcheck contrib module
From: Mark Dilger <mark.dilger@enterprisedb.com>
In-Reply-To: 
 <CA+TgmoY+wdik9JJL_pqR5jPwoJvgU0PbUtp2Akeos5XiiSppvw@mail.gmail.com>
Date: Thu, 28 Jan 2021 09:50:51 -0800
Cc: Thomas Munro <thomas.munro@gmail.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
 Peter Geoghegan <pg@bowt.ie>,
 "Andrey M. Borodin" <x4mmm@yandex-team.ru>,
 Stephen Frost <sfrost@snowman.net>,
 Michael Paquier <michael@paquier.xyz>,
 Amul Sul <sulamul@gmail.com>,
 Dilip Kumar <dilipbalaut@gmail.com>,
 Andres Freund <andres@anarazel.de>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <32B37FF5-7C41-4D43-9CBB-DB357482F162@enterprisedb.com>
References: <12ED3DA8-25F0-4B68-937D-D907CFBF08E7@enterprisedb.com>
 <20200420194210.sevnpi4lyghoanxi@alap3.anarazel.de>
 <23E60C3C-C20A-4508-84AC-E0CEA59E784A@enterprisedb.com>
 <CA+TgmobAm8vB1MNQ1taO1et+HxTN8ULnQvEG+grNDqNQTBjbtA@mail.gmail.com>
 <F845AC50-A479-43F3-ADFB-861A4D2AD287@enterprisedb.com>
 <5F743835-3399-419C-8324-2D424237E999@enterprisedb.com>
 <CAFiTN-syyHc3jZoou51v0SR8z0POoNfktqEO6MaGig4YS8mosA@mail.gmail.com>
 <E6F4258A-B661-4F2C-8A35-278C9436930A@enterprisedb.com>
 <CAFiTN-s-VX3DLfqv7OOo0zGCTOZ3xVU9UZ6GgzBZdJTPNnYFNg@mail.gmail.com>
 <885D2EC9-7D06-4903-A17D-72C184A1E1C5@enterprisedb.com>
 <CAFiTN-uYg_PiZ854=5R-D9skratapAHKhaDAG7fhJv-Vn5UhaQ@mail.gmail.com>
 <5CC85F28-F210-47AC-8DA8-EC4E82AF3FD5@enterprisedb.com>
 <CAFiTN-sP5iFJGERTq4a4OLTCzjZKhLC5P6_k2bxQKXnuvdmzGA@mail.gmail.com>
 <CAFiTN-tTg0R5AHvXC1ro9XphroX1wUtc5t91hU_+7DeGTpE5VQ@mail.gmail.com>
 <0C0349EB-DD85-4DA8-82C7-DF70AB714592@enterprisedb.com>
 <BA6E870F-241C-4DDB-B92D-DB39E679C7D4@enterprisedb.com>
 <C4A3E5AE-CBB2-4E3F-8BAE-29EE216762C2@enterprisedb.com>
 <CAAJ_b96_Xr2a+D0j8xKbOnCzURcVQm0V2DS+T_pfc+wt3BpL8g@mail.gmail.com>
 <9DF93B83-FE46-4EC4-A99D-77A60729FD2D@enterprisedb.com>
 <CA+TgmoZT3kCOaKq6=m5wHGKh_9XQDbCC1LZXL6w_+NMB-n1+mw@mail.gmail.com>
 <CAAJ_b94hsrF4x7UKQj03416fAEXJorUpZ9WhsZZjqgv-4+Wg9A@mail.gmail.com>
 <50F6468F-5A5E-412A-86EC-DF24B549D733@enterprisedb.com>
 <CAAJ_b94+A1Gk5r5sBYbYM2K5hH_gyp_o=+gwJuJhn5ZEm5_rqw@mail.gmail.com>
 <CAAJ_b94Wh_7kM9JuJk7wnNsYSNPdSzz35cOEaE_ZRnPcqvupCg@mail.gmail.com>
 <7D603B53-8078-4AF0-851B-803FF4416501@enterprisedb.com>
 <CA+TgmoZbPtTgkQBGoco39uqKUWuv=0+TOkiNcCuqWWvUkJVuxQ@mail.gmail.com>
 <A4C9E0AE-46BA-457F-A445-4527E5AA5E3C@enterprisedb.com>
 <98265AA9-7BDC-4708-9348-CC1B173BBE1D@enterprisedb.com>
 <CA+Tgmoam+pnGKhWS+RAYCk1eqjhbAPX7Vm69g1VF56xwyxXw+g@mail.gmail.com>
 <209783.1603313248@sss.pgh.pa.us>
 <77A60E99-6054-40FD-A5D6-769C287D4A0F@enterprisedb.com>
 <CA+TgmobGxdm8Tsxawt7LW-qigHRHxD+b17PC+ft9EE+6pMhC9w@mail.gmail.com>
 <721BFA83-EA6F-463D-A9DF-CE78A318B73A@enterprisedb.com>
 <2A7DA1A8-C4AA-43DF-A985-3CA52F4DC775@enterprisedb.com>
 <146814.1603463293@sss.pgh.pa.us> <221029.1603476265@sss.pgh.pa.us>
 <CA+TgmoZsuhZroXdwCNUb5+9QEWSFQMH9=aA1hx-SDeArppH76Q@mail.gmail.com>
 <C001DE91-CF4A-44A7-85B6-8BBAB1881196@enterprisedb.com>
 <CA+TgmoZJ53=joSyJuR7WmXEOfhbBK+0hQBrOO4mWftwekaHS6w@mail.gmail.com>
 <153EEBAD-2673-4367-B36D-4A6AE8EE7A9F@enterprisedb.com>
 <85BE72E5-A926-4F23-9FD5-64239C0C6BA5@enterprisedb.com>
 <CA+Tgmoa7sNcw15=soG1pLBgByMnn-w70YdfKZmhmYOb43KzzRw@mail.gmail.com>
 <B5CF5BFF-0A92-4792-868E-3DB4E8F1C389@enterprisedb.com>
 <10677BFE-3B45-4EF3-82E5-E45CA1445CA6@enterprisedb.com>
 <CA+hUKG+mX5sb6=ZG9=zHaYofPeLOxO910XHkahcDgP-XzEMLxQ@mail.gmail.com>
 <A4C2DFB8-436F-4802-BE8D-7A30290D52FA@enterprisedb.com>
 <CA+TgmoY=+bKef-MUb1nKnyL8nV_26cn7NJ8q50AkGg0fV_v_XA@mail.gmail.com>
 <411C72E5-23A6-485F-A101-FBF7CFA6D2D5@enterprisedb.com>
 <CA+Tgmoa_SfoePsmXfj9FkDFqOCdJyb8XpXUzDo7GahuyPrPnpA@mail.gmail.com>
 <17C26782-A208-4035-8660-42861DA88F25@enterprisedb.com>
 <CA+TgmoY+wdik9JJL_pqR5jPwoJvgU0PbUtp2Akeos5XiiSppvw@mail.gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Precedence: bulk


> On Jan 28, 2021, at 9:49 AM, Robert Haas <robertmhaas@gmail.com> =
wrote:
>=20
> On Thu, Jan 28, 2021 at 12:40 PM Mark Dilger
> <mark.dilger@enterprisedb.com> wrote:
>>> On Jan 28, 2021, at 9:13 AM, Robert Haas <robertmhaas@gmail.com> =
wrote:
>>> If I run pg_amcheck --all -j4 do I get a serialization boundary =
across
>>> databases? Like, I have to completely finish db1 before I can go =
onto
>>> db2, even though maybe only one worker is still busy with it?
>>=20
>> Yes, you do.  That's patterned on reindexdb and vacuumdb.
>=20
> Sounds lame, but fair enough. We can leave that problem for another =
day.

Yeah, I agree that it's lame, and should eventually be addressed.=20

=E2=80=94
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company