Does a Postgres UNIQUE constraint imply an index?

by

Yes.
UNIQUE constraints are implemented using a unique B-tree index in Postgres.

See:

More Related Contents:

  1. How does PostgreSQL enforce the UNIQUE constraint / what type of index does it use?
  2. Postgresql: Conditionally unique constraint
  3. Do nullable columns occupy additional space in PostgreSQL?
  4. CONSTRAINT to check values from a remotely related table (via join etc.)
  5. PostgreSQL LIKE query performance variations
  6. Calculating and saving space in PostgreSQL
  7. Store common query as column?
  8. Making sense of Postgres row sizes
  9. Can PostgreSQL have a uniqueness constraint on array elements?
  10. Why does PostgreSQL perform sequential scan on indexed column?
  11. Does not using NULL in PostgreSQL still use a NULL bitmap in the header?
  12. How to add “on delete cascade” constraints?
  13. Grant all on a specific schema in the db to a group role in PostgreSQL
  14. Why can I create a table with PRIMARY KEY on a nullable column?
  15. Difference between GiST and GIN index
  16. Postgres query optimization (forcing an index scan)
  17. Postgres constraint for unique datetime range
  18. How does PostgreSQL perform ORDER BY with a b-tree index on the field?
  19. Optimize Postgres query on timestamp range
  20. Multicolumn index on 3 fields with heterogenous data types
  21. PostgreSQL – disabling constraints
  22. PostgreSQL Index on JSON
  23. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  24. How to add a conditional unique index on PostgreSQL
  25. PostgreSQL – set a default cell value according to another cell value
  26. PostgreSQL composite primary key
  27. Insert, on duplicate update in PostgreSQL?
  28. How to convert a postgres database to sqlite
  29. SQL Sub queries in check constraint
  30. now() default values are all showing same timestamp

Leave a Comment