Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-16 Thread Thomas Kellerer
Tom Lane-2 wrote > 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 shou

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-16 Thread Vik Fearing
On 16/06/16 20:31, Jim Nasby wrote: > On 6/13/16 12:16 PM, Tom Lane wrote: >> 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. > > On a first go-round, I do

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-16 Thread Pavel Stehule
2016-06-16 20:31 GMT+02:00 Jim Nasby : > On 6/13/16 12:16 PM, Tom Lane wrote: > >> 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. >> > > On a first go-rou

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-16 Thread Jim Nasby
On 6/13/16 12:16 PM, Tom Lane wrote: 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. On a first go-round, I don't think we should add entire views, but rathe

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-13 Thread Tom Lane
Robert Haas writes: > On Mon, Jun 13, 2016 at 3:23 AM, Pavel Stehule > 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 ge

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-13 Thread Pavel Stehule
2016-06-13 18:52 GMT+02:00 Robert Haas : > On Mon, Jun 13, 2016 at 3:23 AM, Pavel Stehule > 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. > > >

Re: [HACKERS] proposal: integration bloat tables (indexes) to core

2016-06-13 Thread Robert Haas
On Mon, Jun 13, 2016 at 3:23 AM, Pavel Stehule 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. > > Mainly queries for detecting table bloat, index bloat, B