Vertica 6 adds a new data value indexing methodology to improve overall query performance!
If you upgrade to Vertica 6 you'll need to re-index your ROSes to take advantage of the new functionality. It's easy to do this but the down side is that your database has to be down.
The following command will scan the entire local storage access layer (SAL) and create a new value index of each data block for all ROSes that are responsible for SAL file changes and local catalog updates.
/opt/vertica/bin/vertica -D catalog_path -i
You have to run the command on each node of your database cluster. Make sure catalog_path is the path to the catalog on the node on which you are running the command.
Here is an example run on one of our test nodes:
Code: Select all
bash-3.2$ /opt/vertica/bin/vertica -D /usr/local/data/vertica/v_vtest01_node0001_catalog -i
Setting up logger and sessions...
Loading catalog...
Collecting storage containers...
Scanning data on disk...
Storages 1982/1982, bytes 3456087746/3456087746 100%
Committing catalog and SAL changes...