Title
#users-public
x

Xavier Lu

10/07/2022, 5:49 PM
is there a column limit for each table? eg is there a max number of columns i can have in each table
Andrey Pechkurov

Andrey Pechkurov

10/07/2022, 6:27 PM
Hi Xavier, There is no enforced limit as such and some of our users have tables with 300-400 columns. If your tables have many columns, you should tweak kernel settings for open files and mmap areas limits:https://questdb.io/docs/operations/capacity-planning#os-configuration P.S. Tweaking these limits is also a must for any production deployment, regardless of the number of tables & columns.
x

Xavier Lu

10/07/2022, 9:38 PM
great thanks @Andrey Pechkurov