On 2019-Aug-20, Rafia Sabih wrote: > This does not sound very convenient. I was thinking of having some > mechanism for such insertions which automatically creates a default > partition and gives a notice for the user to know that it is going to > the default partition. Basically, always having a default partition. > After all default is something that remains there by default, isn't > it?
There are shortcomings to having a default partition, so I don't think this would be an universally welcome feature. I think auto-creation of partitions might be useful in some cases, but not by default since there are caveats (possibility of deadlocks) and not of the default partition. The major problem I see with the default partition is that there's no way to create a partition that overlaps existing contents of the default partition, short of blocking everyone. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
