Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled
Date: 2017-10-27 12:16:12
Message-ID: 1509106572249-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniele Varrazzo 2017-10-27 12:24:50 Linking libpq statically to libssl
Previous Message Alvaro Herrera 2017-10-27 12:06:53 Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled