Re: [GENERAL] bloat indexes - opinion
| От | Jeff Janes |
|---|---|
| Тема | Re: [GENERAL] bloat indexes - opinion |
| Дата | |
| Msg-id | CAMkU=1yHT_ZU98QU4ovnwik8kk4HEJ4mM-R1yzHy_KqE7MBCog@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] bloat indexes - opinion (Patrick B <patrickbakerbr@gmail.com>) |
| Ответы |
Re: [GENERAL] bloat indexes - opinion
|
| Список | pgsql-general |
On Tue, Feb 21, 2017 at 1:44 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
Hi guys,I've got a lot of bloat indexes on my 4TB database.Let's take this example:Table: segIndex: ix_filter_by_treeTimes_used: 1018082183Table_size: 18 GB -- wrong. The table is mostly on pg_toast table. Its real size is 2TBIndex_size: 17 GBNum_writes 16245023Index definition: CREATE INDEX ix_filter_by_tree ON seg USING btree (full_path varchar_pattern_ops) WHERE (full_path IS NOT NULL)
What is this from? If you think the table size reported should include toast, then change it to do that, or request the author of whatever-this-is to make that change.
What indication is there that the index is bloated? If the meat-and-potatoes of a table is held in toast, then wouldn't you expect the size of the table and the size of the index to be about the same?
Cheers,
Jeff
В списке pgsql-general по дате отправления: