-
1. Re: Is it possible to obtain view cache information from the PostgreSQL repository?
Dan ScottMay 28, 2015 11:53 AM (in response to Matt Coles)
The for_cache_updated_at field of the views table is, indeed, actively used, and updated. When a request for a viz is made by some user, information about the view, and its associated workbook, and relevant permissions are cached. If the same user makes a later request for that viz, then Tableau Server will attempt to use the cached information, instead of executing another "largish" SQL query against the Repository. It verifies that it can legitimately use the cached data by comparing the current value of for_cache_updated_at, with the version stored in the existing cached information, and if they are the same, then it is okay to use the cached information---otherwise it re-queries the Repository for all the required information and uses that (and updates the cache information).
Updating of the for_cache_updated_at field of views happens automatically in the Repository (as a result of both rules and triggers) when a change is made to to the view record, or to the workbook record that it belongs to, or to any of the records in next_gen_permissions that affect the permissions relevant to the view.
The actual cached information is stored in a combination of on-disk file and in-RAM caching mechanism. The Repository holds the ultimate source of that information, but I wouldn't say that the cache exists in the Repository, if you see the distinction.
The reason that the field was left out of the data dictionary is simply because it was judged to be one of those implementation details that would only be confusing, since this is not a field that anyone would ever set themselves.
-
2. Re: Is it possible to obtain view cache information from the PostgreSQL repository?
Matt ColesMay 28, 2015 12:38 PM (in response to Dan Scott)
Thanks for confirming Dan! Very helpful answer.