Run Away from VectorWise if implementing Enterprise Data Watehouse

VectorWise was tested and the quick response for SQL involving massive data was one of the attractive features. The cost was also low as compared to the commercial databases. But after implementing multiple projects in VectorWise we learned it handles parallel ETL loads and high concurrent user poorly. Most of the time with users logged in to BI tools on top of VectorWise the database became dormant and we had to restart the server. ETL loads when run for a single project would run fine, but with multiple project ETL starting in parallel, the databse would respond very poorly. After close to two years we decided to move away from VectorWise and decommissioned VectorWise. VectorWise was a bad candidate to be the enterprise data warehouse database. For a data mart or ODS it may be a suitable candidate.