Block size error on Database creation
Hello Community,
I got the below error while creating a new database.
.png)
Product version: IRIS 2023.2
$ZV: IRIS for Windows (x86-64) 2023.2 (Build 227)
Discussion (7)2
Log in or sign up to continue
https://community.intersystems.com/post/block-size-error-database-creation
Check this page from the documentation.
Just need to enable it in settings.png)
Hello @Dmitry Maslennikov
I had enabled the options and restarted the iris before creating the database. Still I got the error
Ahh, yes, you also need some Global Buffer for this size too
Thanks @Dmitry Maslennikov
It works. I thought "Initial (25% of physical memory)" of the global buffer will also applicable for other block size. However It's not that kind. There is default 0 for those blocks. So, it's mandatory to make it specific amount.
Once I made the changes it works!
I'd love to know more about your specific use case for using 32KB blocks for the database. In my experience, 8KB blocks are generally more adaptable unless you're exclusively working with atomic data elements that are that size or larger. IMHO, it's an instance wide consideration rather than only a database level consideration because allocating buffers of 32KB reserves a portion of the memory for blocks of that size.
Hello @Chad Severtson
We have streams to store it for long time. So, As per the documentation. I was thinking to to create a separate database to move the existing streams, create a new streams and maintain it accordingly. Can you add bit more details about this
the instance wide consideration rather than only a database level consideration because allocating buffers of 32KB reserves a portion of the memory for blocks of that sizeHow much memory is allocated and how to calculate itThanks!