Skip site navigation (1) Skip section navigation (2)

Feature Description

Abbreviated Keys

The abbreviated keys optimization can be expected to greatly enhance the performance of sorts in PostgreSQL, including those used for CREATE INDEX. Reportedly, in some cases, CREATE INDEX on text columns can be as much as an entire order of magnitude faster (3x is a more typical improvement). Numeric sorts also support the optimization.


Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group