2016-06-13 18:52 GMT+02:00 Robert Haas <robertmh...@gmail.com>: > 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. > > > > Mainly queries for detecting table bloat, index bloat, But some queries > over > > pg_locks should be useful too. > > > > Notes, comments? > > 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. >
maybe estimated pgstattuple functions ? but bloating is too important, so I would to see solution in core more. Regards Pavel > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >