Postgres Pro
Downloads
Home   >   mailing lists

Re: ltree + gist index performance degrades significantly over a night - Mailing list pgsql-general

From Tom Lane
Subject Re: ltree + gist index performance degrades significantly over a night
Date
Msg-id 4495.1140803538@sss.pgh.pa.us
Whole thread Raw
In response to Re: ltree + gist index performance degrades significantly over a night  (CG <cgg007@yahoo.com>)
List pgsql-general
Tree view 
CG <cgg007@yahoo.com> writes:
> INFO:  index "search_vector_idx" now contains 1344672 row versions in 47725 pages
> INFO:  "letter_search": found 9 removable, 1344661 nonremovable row versions in 33984 pages

Yikes ... the index is bigger than the table!  Seems like you've not
been vacuuming enough, or else gist has got a major bloat problem.
If you REINDEX, does the index get materially smaller?

            regards, tom lane

pgsql-general by date:

Previous
From: Tomi NA
Date:
Subject: Re: collation & UTF-8
Next
From: Tom Lane
Date:
Subject: Re: collation & UTF-8