FullText Index Disk/Memory Usage

Hi!

How might one estimate the disk and/or memory usage impact of a fulltext index? How does it compare to a hash index, for example?

Thanks!

Fulltext indexes are on disk. They only work with columnstore tables. The index data is brought in to memory on demand during query execution. Like any data from disk in the columnstore, recently accessed data will stay in the Linux file system buffer pool based on its replacement policy.

Total disk usage by a fulltext index really depends on the data, but on average, it is similar to the original text.

Run this to get information about disk usage for fulltext indexes:

select * from information_schema.mv_columnstore_files where file_type = 'FULLTEXT'

3 Likes

Great, thank you for this info!

1 Like