What is the maximum size transaction that will be relayed by bitcoin nodes using the default configuration?

I understand that the actual size limit of a transaction is determined by the block size, as we can see from this absolute unit. But transactions this large must be submitted directly to a mining pool because they will not propagate through the bitcoin network.

What limits prevent this transaction from being relayed? Is it configurable? What units are used (absolute size or weight units)? Is there an associated fee rate limit that also applies?

I understand that the actual size limit of a transaction is determined by the block size, as we can see from this absolute unit. But transactions this large must be submitted directly to a mining pool because they will not propagate through the bitcoin network.

What limits prevent this transaction from being relayed? Is it configurable? What units are used (absolute size or weight units)? Is there an associated fee rate limit that also applies?