Re: [HACKERS] Proposal: global index - Mailing list pgsql-hackers

From Adam Brusselback
Subject Re: [HACKERS] Proposal: global index
Date
Msg-id CAMjNa7d5W6SQ=2w1ghH5bwtWj5n38WH-Yvu_rYa45sKgc+QByA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Proposal: global index  (Chris Travers <chris.travers@adjust.com>)
Responses Re: [HACKERS] Proposal: global index  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
My understanding is that global indexes allow foreign keys to work naturally with partitioned tables, or tables in an inheritance hierarchy.  That is pretty big IMO, as it allows you to partition a table without making a trade-off in your database integrity.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCH] Push limit to sort through a subquery
Next
From: Tom Lane
Date:
Subject: [HACKERS] More replication race conditions