Postgres Pro
Downloads
Home   >   mailing lists

Using indexUnchanged with nbtree - Mailing list pgsql-hackers

From Simon Riggs
Subject Using indexUnchanged with nbtree
Date
Msg-id CANbhV-EVCfUsDRP42LU_0B75ZR+jnsorap+T_JKBr4WaAQPsgA@mail.gmail.com
Whole thread Raw
Responses Re: Using indexUnchanged with nbtree  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
Seems like we can skip the uniqueness check if indexUnchanged, which
will speed up non-HOT UPDATEs on tables with B-Trees.

Passes tests.

Comments?

-- 
Simon Riggs                http://www.EnterpriseDB.com/
Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic
Next
From: Simon Riggs
Date:
Subject: Doc chapter for Hash Indexes