That's up to the relay operator, but if you delete your nsec and no one else has a copy then no one can ever post under that account again. But public relays will inevitably delete old notes as space runs out.