bloat indexes - opinion

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: bloat indexes - opinion
Date: 2017-02-21 21:44:04
Message-ID: CAJNY3iuqLjsBotLM+cGR8+WvvxLNirLaBOz-9A3ACqTrWfn-gQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

I've got a lot of bloat indexes on my 4TB database.

Let's take this example:

Table: seg
Index: ix_filter_by_tree
Times_used: 1018082183
Table_size: 18 GB -- wrong. The table is mostly on pg_toast table. Its real
size is 2TB
Index_size: 17 GB
Num_writes 16245023
Index definition: CREATE INDEX ix_filter_by_tree ON seg USING btree
(full_path varchar_pattern_ops) WHERE (full_path IS NOT NULL)

What is the real impact of a bloat index? If I reindex it, queries will be
faster?

Thanks
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Job 2017-02-21 21:49:36 R: Search on very big (partitioned) table
Previous Message David G. Johnston 2017-02-21 21:38:47 Re: NOTIFY command impact