json on child table or not - Mailing list pgsql-general

From PegoraroF10
Subject json on child table or not
Date
Msg-id 1559308821969-0.post@n3.nabble.com
Whole thread Raw
Responses Re: json on child table or not
List pgsql-general
I have a table with lots of updates in a json field and few updates on other
fields. On that table I have several indices and it is main table of other
lots of child tables.
When querying this table I always do a lateral join with that json field, so
having that field on a separate table wouldn´t be a problem.

Then, for auto vacuum, for indices, for fillfactor and some other reasons,
is it better to have that json on a child table in a 1 to 1 relation ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: table is hanging
Next
From: Ivan Voras
Date:
Subject: Feature request (or at least discussion): enable autovaccum on temp tables