So as I understand it, new transactions are new tips of the tangle, and older transactions are more and more unlikely to be picked.
At what point are illegal or unconfirmed transactions removed from the full node database?
So as I understand it, new transactions are new tips of the tangle, and older transactions are more and more unlikely to be picked.
At what point are illegal or unconfirmed transactions removed from the full node database?
They will get removed (together with the confirmed transactions) at the next snapshot.
Permanodes will keep them forever (if they have ever seen them; it is not guaranteed for unconfirmed transactions that every node will eventually see them)