Is there a Vertica Cache?

[jane]

Hello all,

When tuning queries in Oracle we use the ALTER SYSTEM FLUSH SHARED_POOL command to give a base line. This way queries won't benefit from any cached information.

Is there something similar in Vertica? Does Vertica even cache query results/explain plans?

[JimKnicely]

Hi Jane,

You can use the CLEAR_CACHES() function.

Code: Select all

dbadmin=> select clear_caches();
 clear_caches 
--------------
 Cleared
(1 row)

Reference:
https://my.vertica.com/docs/6.1.x/HTML/ ... #20285.htm

[Julie]

Does that CLEAR_CACHES() function clear the cache for all sessions or just the one that executes it?