Vertica 6 and Improved Data Indexing

[JimKnicely]

Hi all,

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...

[rajasekhart]

It's easy to do this but the down side is that your database has to be down.

Hi Jim,

What do you mean ?

Should i stop the database before proceeding the steps given by you?????

And then i start the database after completion of this process??

Thanks,
Raj.

[rajasekhart]

Hi Skwa,

Thanks for your info.

"If it is upgraded from VERTICA 5 to VERTICA 6 (using != upgrade), then it is needed to re- index it,
else it is not needed to reindex. By default new functionalities are available in vertica 6."

Raj!!

[id10t]

HI!

Yeap, is it:

For new customers, the Vertica database uses the improved indexing techniques and stores and retrieves data using CRC by default. Existing customers who upgrade must upgrade each cluster node from the command line when the database cluster is DOWN (offline).

Improved Data Indexing and CRC Implementation