Pin data in memory

Moderator: NorbertKrupa

Post Reply
harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Pin data in memory

Post by harryrundles » Tue Aug 25, 2015 6:33 pm

Howdy all,

Is it possible to pin (cache) a table's data in RAM so that the DB doesn't have re-read it from disk later?
Thanks,
Harry

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Pin data in memory

Post by NorbertKrupa » Wed Aug 26, 2015 2:12 pm

Hypothetical question... What if the table changes, and the table is 500GB? Should it get re-loaded into memory each time?
Checkout vertica.tips for more Vertica resources.

harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Re: Pin data in memory

Post by harryrundles » Wed Aug 26, 2015 2:44 pm

Hi, Thanks for getting back to me. I was thinking more on the line of tables that do not change that often, if at all, and that are queried a lot - like dimension tables.
Thanks,
Harry

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Pin data in memory

Post by nnani » Tue Sep 01, 2015 9:19 am

Hi,

The basic answer would be....Vertica is not an In memory database.

The functionality, you are looking for, is found in In-memory databases(Voltdb and many more).

Plus, there is no such solution as memcache sitting on Vertica as of yet..

This https://community.dev.hp.com/t5/Vertica ... d-p/216561topic might help.
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “New to Vertica Database Administration”