a lot of custom fields

Like Joel M asked, it really depends on what you mean by “a lot of posts”. It also depends a lot on if you’re querying these posts in complicated ways.

I highly recommend you install the plugin Query Monitor (https://wordpress.org/plugins/query-monitor/). It will tell you how long various queries are taking. You can then create “a lot of [test] posts” and see if your queries start running slowly.