phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sumit Nigam <>
Subject Re: Block Cache
Date Thu, 05 Nov 2015 09:39:44 GMT
Now, I have a question. Are secondary indexes maintained in block cache? 
When I describe one of my indexes, I see - IN_MEMORY => 'false', BLOCKCACHE => 'true'
Does this mean that the index does not reside in memory? Should I explicitly set IN_MEMORY=true
when I create index?
      From: Sumit Nigam <>
 To: "" <>; Sumit Nigam <>

 Sent: Thursday, November 5, 2015 2:42 PM
 Subject: Re: Block Cache
Sorry, do not bother. I figured out - can be done by specifying BLOCKCACHE=false at create
table time.

     From: Sumit Nigam <>
 To: Users Mail List Phoenix <> 
 Sent: Thursday, November 5, 2015 1:58 PM
 Subject: Block Cache
Is there an easy way to completely turn off block cache for a specific table at table creation
time itself? Something like, CREATE TABLE X ( ..... ) BLOCK_CACHE=FALSE;
I could likely hint the queries during read time, but setting I'd like to turn it off completely.


View raw message