What volume setting do the Twitter and Facebook apps obey?
1) App notifications use the Ringer volume for how loud the notification is played.

2) You could use an application like Locale or Tasker to automatically silence your Ringer volume during the night.  Then you could create exceptions if you need for certain people to be able to call you during the night.