I have a table in an ordinary ingres database which has 450million rows. It has a three element primary key and we have to update one of those columns from -1 to zero. The question was are there any cases where we would get a key violation...
It took less time to transfer the table via a FIFO node to an installation with vectorwise, load it into to a dummy database, and then run the appropriate query there to determine the answer, then it took on the normal Ingres installation.
The query on Vectorwise took less than ten seconds!
We gave up on the standard installation.