Re: Missing TOAST table for pg_class

2020-09-23 Thread Michael Paquier
On Wed, Sep 23, 2020 at 06:11:06PM -0300, Fabrízio de Royes Mello wrote: > Adding a TOAST can cause circular dependencies between those relations?? If > you don't mind can you explain more about it? The difficult task here is to make sure that we don't have any corner cases that begin to break bec

Re: Missing TOAST table for pg_class

2020-09-23 Thread Fabrízio de Royes Mello
On Tue, Sep 22, 2020 at 10:57 PM Michael Paquier wrote: > > On Tue, Sep 22, 2020 at 05:35:48PM -0400, Tom Lane wrote: > > What exactly do you argue has changed since the previous decision > > that should cause us to change it? In particular, where is the > > additional data to change our minds ab

Re: Missing TOAST table for pg_class

2020-09-22 Thread Michael Paquier
On Tue, Sep 22, 2020 at 05:35:48PM -0400, Tom Lane wrote: > What exactly do you argue has changed since the previous decision > that should cause us to change it? In particular, where is the > additional data to change our minds about the safety of such a thing? Not sure that's safe, as we also w

Re: Missing TOAST table for pg_class

2020-09-22 Thread Tom Lane
=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes: > Attached patch adds the TOAST to pg_class, and let's open again the > discussion around it. What exactly do you argue has changed since the previous decision that should cause us to change it? In particular, where is the additional data to chang

Missing TOAST table for pg_class

2020-09-22 Thread Fabrízio de Royes Mello
Hi all, I know it has been discussed before [1] but one of our customers complained about something weird on one of their multi-tenancy databases (thousands of schemas with a lot of objects inside and one user by schema). So when I checked the problem is because the missing TOAST for pg_class, an