[HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема [HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled
Дата
Msg-id 1509106572249-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: [HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
akapila wrote:

> You might want to give a try with the hash index if you are planning
> to use PG10 and your queries involve equality operations.

But you can't replace the PK index with a hash index, because hash indexes
don't support uniqueness.




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: [HACKERS] Linking libpq statically to libssl