Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of potekhin@bnl.gov designates
 130.199.3.132 as permitted sender)
Message-ID: <4E178AFD.7060604@bnl.gov>
Date: Fri, 08 Jul 2011 18:55:57 -0400
From: Maxim Potekhin <potekhin@bnl.gov>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US;
 rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Performance deterioration while building secondary index
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I have roughly 150 million rows in my database, which will grow as I 
continue testing. I'm building an index on a particular column, via 
cassandra-cli, something of the sort:
update column family jobs with column_metadata = [{column_name : 'DATE', 
       validation_class : AsciiType, index_type : 0, index_name : 'date'}]

At this point, the cluster just becomes unresponsive -- just doing 
"list" on a CF takes a while. Random query test I used to run rather 
quickly, becomes terribly slow (hasn't returned since I started typing 
this).

Is that normal? I can' imagine this happening in a production situation, 
when I decided to add an index for some valid reasons. Really scratching 
my head now. TIA.

The version is 0.8.1

Thanks!