Re: ltree + gist index performance degrades significantly over a night

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: ltree + gist index performance degrades significantly over a night
Date: 2006-02-24 17:52:18
Message-ID: 4495.1140803538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CG <cgg007(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-24 17:57:51 Re: collation & UTF-8
Previous Message Tomi NA 2006-02-24 17:45:40 Re: collation & UTF-8