Re: Inconsistent use of relpages = -1

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: Inconsistent use of relpages = -1
Дата
Msg-id
c078ff8ff48750452ac21455148500030ff9c8e8.camel@j-davis.com
Ответ на
Список
Дерево обсуждения
Inconsistent use of relpages = -1 Jeff Davis <pgsql@j-davis.com>
Re: Inconsistent use of relpages = -1 Tom Lane <tgl@sss.pgh.pa.us>
On Wed, 2024-10-23 at 04:47 +0200, Laurenz Albe wrote:
> On Tue, 2024-10-22 at 10:41 -0700, Jeff Davis wrote:
> > I attached a patch that creates partitioned tables with relpages=-
> > 1,
> > and updates the docs.
> 
> Does this need any changes for pg_upgrade?

pg_upgrade would go through the same DDL path, so I expect it would be
set to -1 in the upgraded cluster anyway. Are you seeing something
different?

In any case, the change is just meant to improve consistency and
documentation. I didn't intend to create a hard guarantee that it would
always be -1, so perhaps I should make the documentation more vague
with "may be" instead of "is"?

It bothers me somewhat that views still have relpages=0, because they
also don't have storage. Thoughts?

Regards,
	Jeff Davis



В списке pgsql-hackers по дате отправления
От: Heikki Linnakangas
Дата:
От: Tom Lane
Дата:
FAQ