Re: proposal: integration bloat tables (indexes) to core

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: integration bloat tables (indexes) to core
Дата
Msg-id CAFj8pRB0DfGk2pSSg73EojqZWjGfmwQd+fipvyHjssQjTv4ijA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: integration bloat tables (indexes) to core  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: proposal: integration bloat tables (indexes) to core
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: ORDER/GROUP BY expression not found in targetlist