Is it more efficient to create check constraints on PostgreSQL table before or after bulk load?
You can benchmark it, but it shouldn't make a difference. The check expression will be evaluated for each row, and it only uses the data from that row. It should make no difference if that takes place while you load the data or afterwards.