On 2013-12-18 10:41, Kevin Grittner wrote:
> Dean Gibson (DB Administrator) <postgresql@ultimeth.com> wrote:
>
>> ... that clearly spends some time building a separate index.
> No it doesn't. If you are observing activity at that time, it is probably from validating that the constraint is
initiallyvalid.
Ah ha! That's what's consuming the time! Thanks!
>
>> 5. If I need the separate index on Y, should it be built before or after the FOREIGN KEY constraint?
> In some cases it may allow faster initial validation of the constraint; if I wanted the index I would probably build
itbefore adding the constraint.
Again, that's what I needed to know! Thanks again!
--
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.