This is definitely not true. They are not generic at all. * work_mem is postgres specific * stored procs and functions don't perform as badly in SQL Server *

This is definitely not true. They are not generic at all. * work_mem is postgres specific * stored procs and functions don't perform as badly in SQL Server * Triggers behave differently * NOTIFY is postgres specific etc.