How to perform an action after the time has elapsed? Won't cron be too expensive?

Question

PostgreSQL

there is a table (message, date) with a message that needs to be sent at a specific time. The problem is that the accuracy should preferably be very high, and the table is not small. are there any more concise solutions than cron

Answer 1

not small - the concept is very relative. if the selection of the desired dates really takes a lot of time, you can do the aggregation, for example, for the next day/week/several hours.
or get confused by the scheduler in the database itself.