my current preference are as follows postgresql for transactional logs clickhouse for analytics data elasticsearch or quickwit for terabytes of data, disk pe

my current preference are as follows postgresql for transactional logs clickhouse for analytics data elasticsearch or quickwit for terabytes of data, disk persisted, if i need thorough search on structured jsons --- others i use for different use case typesense for searching mbs to gbs of data, memory persisted redis for caching kbs of data, memory persisted