[HACKERS] Burst in WAL size when UUID is used as PK while full_page_writes areenabled

Поиск
Список
Период
Сортировка
От sanyam jain
Тема [HACKERS] Burst in WAL size when UUID is used as PK while full_page_writes areenabled
Дата
Msg-id MAXPR01MB04921E5B05F67C25C2A895B8C05A0@MAXPR01MB0492.INDPRD01.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers

Hi,

I was reading the blog https://blog.2ndquadrant.com/on-the-impact-of-full-page-writes .

My queries:

How randomness of UUID will likely to create new leaf page in btree index?
In my understanding as the size of UUID is 128 bits i.e. twice of BIGSERIAL , more number of pages will be required to store the same number of rows and hence there can be increase in WAL size due to FPW .
When compared the index size in local setup UUID index is ~2x greater in size.


Thanks,

Sanyam Jain

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

Предыдущее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: Re: [HACKERS] proposal: schema variables
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] path toward faster partition pruning