Actian Community Blogs

An exciting new agenda topic was added to the 2011 UK IUA this year allowing attendees to suggest and vote on features to add to the Ingres family of products. The Ingres family of products include but not limited to Ingres, OpenROAD, and VectorWise. This new informal gathering was very well received with so many suggestions that we ran out of time to discuss. Even if you were not able to bring your proposed feature before the group the ability to get your feature added to the list was still possible...

[Thanks to http://atom.smasher.org/highway/]

It's been about a month since I last posted anything about VectorWise. I have been rather distracted by the UK IUA conference on June 8, normal everyday work, life, but mostly by the project that I am writing about today.

This project started after I (frankly) hit the wall with the machine I've been writing about in my earlier postings. It was nice and fast for what it was, but some off-line emails made it clear people were less interested in breathing new life into systems assembled...

So far, out of the 20 or 30 significantly complicated SELECT statements I've thrown at VectorWise, it has simply executed them. The most I've had to change is non-standard syntax like "LIMIT 50" at the end of the query to "FIRST 50" at the start.

Only one of the queries (originally intended for MySQL) has caused it to complain:
...

I've not posted anything for a few days, and it looks like today is going to be spent unloading my database so I can install VectorWise 1.0. As much as I've enjoyed playing with the 0.8 release, the extra features in 1.0 are too inviting to ignore, and besides, what would be the point of familiarizing myself with the features (and limitations) of a stale version?

I'm using unloaddb in the usual way. Most of the most frequently used utilities work with VectorWise, with only a few...