Like it says at the bottom of every 5-6 emails :
subscribe and unsubscribe commands go to majordomo@postgresql.org
OR
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
It's quite simple really.