Re: Add parallelism and glibc dependent only options to reindexdb

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Add parallelism and glibc dependent only options to reindexdb
Дата
Msg-id 20190728163418.bolniw34m7u3dhio@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Add parallelism and glibc dependent only options to reindexdb  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Add parallelism and glibc dependent only options to reindexdb  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

On 2019-07-28 10:07:27 -0400, Tom Lane wrote:
> In the long run, might we ever switch to 64-bit OIDs?  I dunno.
> Now that we kicked them out of user tables, it might be feasible,
> but by the same token there's not much pressure to do it.

Depends on the the table, I'd say. Having toast tables have 64bit ids,
and not advance the oid counter, would be quite the advantage over the
current situation. Toasting performance craters once the oid counter has
wrapped. But obviously there are upgrade problems there - presumably
we'd need 'narrow" and 'wide' toast tables, or such.

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Testing LISTEN/NOTIFY more effectively
Следующее
От: Andres Freund
Дата:
Сообщение: Re: ANALYZE: ERROR: tuple already updated by self