Re: proposal: integration bloat tables (indexes) to core - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: integration bloat tables (indexes) to core
Date
Msg-id CAFj8pRB0DfGk2pSSg73EojqZWjGfmwQd+fipvyHjssQjTv4ijA@mail.gmail.com
Whole thread Raw
In response to Re: proposal: integration bloat tables (indexes) to core  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers


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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: proposal: integration bloat tables (indexes) to core
Next
From: Tom Lane
Date:
Subject: Re: ERROR: ORDER/GROUP BY expression not found in targetlist