Amazon Redshift is completely based on PostgreSQL, but they have implemented some features not currently available in PostgreSQL. Given the fact that it's a successful customer-driven commercial project, one can easily guess that the functions they implemented are useful and requested by many users.