n00b question re: indexes and constraints

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: n00b question re: indexes and constraints
Date: 2020-04-22 18:25:22
Message-ID: CAOC+FBUcDbLb=fjwUzTyTrdfhLu81M9uGdqwfK=BFG3QU5iZuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hope all are well.

Are constraints also indexes, or would you want an additional index on top
of a constraint if you wanted that column/combo indexed?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-04-22 18:30:47 Re: n00b question re: indexes and constraints
Previous Message Yannick Collette 2020-04-22 18:09:21 Re: checkpoint starting: time (insert statement hangs