Robert Haas <robertmh...@gmail.com> writes: > On Mon, Jun 13, 2016 at 3:23 AM, Pavel Stehule <pavel.steh...@gmail.com> > wrote: >> There are lot of useful queries (views), that are on our wiki. Some queries >> are necessary for maintenance, and I am thinking these queries should be >> integrated part of Postgres.
> It's likely to be hard to get agreement on which things to include. > But if we can, it might be worth doing. It would be nice to do it as > an extension. The problem with an extension is: when we make a core change that breaks one of these views, which we will, how can you pg_upgrade a database with the extension installed? There's no provision for upgrading an extension concurrently with the core upgrade. Maybe there should be, but I'm unclear how we could make that work. At the same time, I'm pretty suspicious of putting stuff like this in core, because the expectations for cross-version compatibility go up by orders of magnitude as soon as we do that. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers