I have been running a QuestDB instance for a while, and I have upgraded since then to at least two major versions and to different hardware. I remember when I was first setting up I fine-tuned some config parameters for worker threads and table storage caches, but I cannot really remember which ones I changed.
I would like to review my config to see if I can get better performance using the defaults or maybe tuning for my new hardware, but other than comparing an empty server.conf file to my current one I cannot think of a good way, and I would rather avoid that as it is error-prone.
Do I have any good options here?
Probably the easiest way to see what has been changed is using the SHOW PARAMETERS function. It shows all the properties that can be changed and it also shows if a property is using the default value or it is being overriden (via environment variable or via entry in the server.conf file).
This query should tell us all the properties we have customized.
(show parameters) where value_source <> 'default'