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.
- Re: [HACKERS] Proposal: global index Chris Travers
- Re: [HACKERS] Proposal: global index Ildar Musin
- Re: [HACKERS] Proposal: global index Erikjan Rijkers
- Re: [HACKERS] Proposal: global index Alvaro Herrera
- Re: [HACKERS] Proposal: global index Ildar Musin
- Re: [HACKERS] Proposal: global index Alvaro Herrera
- Re: [HACKERS] Proposal: global index Ildar Musin
- Re: [HACKERS] Proposal: global index Alvaro Herrera
- Re: [HACKERS] Proposal: global index Simon Riggs
- Re: [HACKERS] Proposal: global index Chris Travers
- Re: [HACKERS] Proposal: global index Adam Brusselback
- Re: [HACKERS] Proposal: global index Joshua D. Drake
- Re: [HACKERS] Proposal: global index Andres Freund
- Re: [HACKERS] Proposal: global index Chris Travers
- Re: [HACKERS] Proposal: global index Petr Jelinek
- Re: [HACKERS] Proposal: global index Chris Travers
- Re: [HACKERS] Proposal: global index Ildar Musin
- Re: [HACKERS] Proposal: global index Robert Haas