On Mon, Nov 30, 2020 at 8:36 AM Nick Cleaton <nick(at)cleaton(dot)net> wrote:
> I want to set up a large table on postgresql 12.4, using declarative
> partitioning to partition by record creation date. I'd like to have recent
> records in small partitions but old records in a few larger partitions, so
> I want merges. The merges should be concurrent, in the sense that they lock
> out readers or writers only for very short intervals if at all.
>
Once a date has passed is the table for that date effectively read-only?