json on child table or not

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема json on child table or not
Дата
Msg-id 1559308821969-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: json on child table or not  (Michael Lewis <mlewis@entrata.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: table is hanging
Следующее
От: Ivan Voras
Дата:
Сообщение: Feature request (or at least discussion): enable autovaccum on temp tables