Hi, I have been testing a 4 node cluster with Vertica 6.1.3 with some of our standard queries. When I test with 1 node down, query performance drops dramatically for some (but not all) queries, now they are running 10-20x slower. Looked at the execution plan for both scenarios of 1 particular query,...

One thing to have in mind is not to use straight SHA or any other hash functions to encrypt passwords without salt. Hashed non strong passwords can be easily decrypted with a rainbow table. To use your 'dog' example below, a simple Google search will reveal the password just by searching for the has...