Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled - Mailing list pgsql-hackers

From Thomas Kellerer
Subject [HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled
Date
Msg-id 1509106572249-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] Re: Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Burst in WAL size when UUID is used as PK whilefull_page_writes are enabled
Next
From: Daniele Varrazzo
Date:
Subject: [HACKERS] Linking libpq statically to libssl