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?
Pin data in memory
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 96
- Joined: Thu Jul 19, 2012 12:33 am
Pin data in memory
Thanks,
Harry
Harry
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Pin data in memory
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.
-
- Intermediate
- Posts: 96
- Joined: Thu Jul 19, 2012 12:33 am
Re: Pin data in memory
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
Harry
Re: Pin data in memory
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.
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.