> On Dec 9, 2016, at 22:52, Keith Fiske <ke...@omniti.com> wrote: > On Fri, Dec 9, 2016 at 10:01 PM, Robert Haas <robertmh...@gmail.com> wrote: >> One thing that's tricky/annoying about this is that if you have a >> DEFAULT partition and then add a partition, you have to scan the >> DEFAULT partition for data that should be moved to the new partition. >> That makes what would otherwise be a quick operation slow. Still, I'm >> sure there's a market for that feature. > > I would find that perfectly acceptable as long as a caveat about the > performance impact was included in the documentation.
+1. I don't think it's conceptually different from adding a column with a default, in that regard; you just have to know the impact. -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers