On Wed, 2 Dec 2020 at 16:07, David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Mon, Nov 30, 2020 at 8:36 AM Nick Cleaton <n...@cleaton.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? > No, old records get updated from time to time, although updates are much less common than for recent records.
