You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Dimpal Gurabani <di...@gmail.com> on 2023/06/12 12:55:42 UTC
Impact of column names on storage
Hi all,
We have a table with 15 columns and ~1M rows. Looking at the output of the
sstabledump tool, it seems like column names are stored in the cell for
each row. Is this understanding correct or just sstabledump showing verbose
output? If yes, is it recommended to have small column names to save on
space usage?
--
Thanks and Regards,
Dimpal
Re: Impact of column names on storage
Posted by Dimpal Gurabani <di...@gmail.com>.
Understood! Thank you for the help.
On Mon, Jun 12, 2023 at 7:15 PM Bowen Song via user <
user@cassandra.apache.org> wrote:
> Actually, I was wrong. The column names are not stored in the *-Data.db
> files, but stored in the *-Statistics.db files. Cassandra only stores one
> copy of the column names per SSTable data file, therefore the disk space
> usage is negligible.
>
>
> On 12/06/2023 14:31, Bowen Song wrote:
>
> The SSTable compression will take care of the storage space usage, which
> means users usually don't need to worry about the length of column names,
> unless they are ridiculously long and hard to compress, or if SSTable
> compression is turned off.
>
>
> On 12/06/2023 13:55, Dimpal Gurabani wrote:
>
> Hi all,
>
> We have a table with 15 columns and ~1M rows. Looking at the output of the
> sstabledump tool, it seems like column names are stored in the cell for
> each row. Is this understanding correct or just sstabledump showing
> verbose output? If yes, is it recommended to have small column names to
> save on space usage?
>
> --
> Thanks and Regards,
> Dimpal
>
>
--
Thanks and Regards,
Dimpal
Re: Impact of column names on storage
Posted by Bowen Song via user <us...@cassandra.apache.org>.
Actually, I was wrong. The column names are not stored in the *-Data.db
files, but stored in the *-Statistics.db files. Cassandra only stores
one copy of the column names per SSTable data file, therefore the disk
space usage is negligible.
On 12/06/2023 14:31, Bowen Song wrote:
>
> The SSTable compression will take care of the storage space usage,
> which means users usually don't need to worry about the length of
> column names, unless they are ridiculously long and hard to compress,
> or if SSTable compression is turned off.
>
>
> On 12/06/2023 13:55, Dimpal Gurabani wrote:
>> Hi all,
>>
>> We have a table with 15 columns and ~1M rows. Looking at the output
>> of the sstabledump tool, it seems like column names are stored in the
>> cell for each row. Is this understanding correct or just sstabledump
>> showing verbose output? If yes, is it recommended to have small
>> column names to save on space usage?
>>
>> --
>> Thanks and Regards,
>> Dimpal
Re: Impact of column names on storage
Posted by Bowen Song via user <us...@cassandra.apache.org>.
The SSTable compression will take care of the storage space usage, which
means users usually don't need to worry about the length of column
names, unless they are ridiculously long and hard to compress, or if
SSTable compression is turned off.
On 12/06/2023 13:55, Dimpal Gurabani wrote:
> Hi all,
>
> We have a table with 15 columns and ~1M rows. Looking at the output of
> the sstabledump tool, it seems like column names are stored in the
> cell for each row. Is this understanding correct or just sstabledump
> showing verbose output? If yes, is it recommended to have small column
> names to save on space usage?
>
> --
> Thanks and Regards,
> Dimpal
Re: Impact of column names on storage
Posted by manish khandelwal <ma...@gmail.com>.
I think it is verbose to make it readable in sstableoutput. Column names
should not have any impact of final space usage.
On Mon, Jun 12, 2023 at 6:25 PM Dimpal Gurabani <di...@gmail.com>
wrote:
> Hi all,
>
> We have a table with 15 columns and ~1M rows. Looking at the output of the
> sstabledump tool, it seems like column names are stored in the cell for
> each row. Is this understanding correct or just sstabledump showing
> verbose output? If yes, is it recommended to have small column names to
> save on space usage?
>
> --
> Thanks and Regards,
> Dimpal
>