[identity profile] aethereal-girl.livejournal.com 2008-08-17 05:08 am (UTC)(link)
I believe it's a Carlebach tune. In any case, it's quite common in Modern Orthodox shuls, and used for lots of different parts of the liturgy. Probably most often Lecha Dodi, although I think it works better for Psalm 29. I am not sure which words it was originally written for, if any.