From: Joshua D. Drake <jd@commandprompt.com>
To: Teodor Sigaev <teodor@sigaev.ru>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: GiST notice
Date: Wed, 06 Jul 2005 09:23:22 -0700
Message-ID: <42CC057A.9060105@commandprompt.com> (raw)
In-Reply-To: <42CBFE69.9070408@sigaev.ru>
References: <42CBFE69.9070408@sigaev.ru>
Teodor Sigaev wrote:
> It should be mentioned in documentation that after pgsql's crash GiST
> indexes may restore some "incorrect way": with invalid tuples. Of
> course, not every time. Index will work absolutly correct but possibly
> with some performance degradation (not big). 'Vacuum full' resolves this
> problem and repairs invalid tuples.
Can you also use reindex?
Sincerely,
Joshua D. Drake
> If that problem is detected during recovery, postgres says to log :
> LOG: Detected incomplete insert into GiST index 1663/16385/16458; It's
> desirable to vacuum or reindex index
> More, if usial vacuum will say on such index:
> NOTICE: It's desirable to vacuum full or reindex GiST index 'idx' due
> to crash recovery
> Sorry, but my English doesn't make it possible to write correct phrase
> to documentation. May be thats phrases too...
>
>
> Just for reminder, I found strange trap on vacuum running concurrently
> with a lot of other queries:
> http://www.pgsql.ru/db/mw/msg.html?mid=2077426
> http://www.pgsql.ru/db/mw/msg.html?mid=2078029
> In short:
> it caused approximatly one time per 2-4 million statements (with my
> scripts at http://www.sigaev.ru/gist/, PIII/1133 MHz and Quad
> Xeon/500MHz), I got traps:
> TRAP: FailedAssertion("!((*curpage)->offsets_used == num_tuples)", File:
> "vacuum.c", Line: 2766)
> LOG: server process (PID 15847) was terminated by signal 6
> It's definitly bug in a vaccum code, I got the same trap without any GiST
> indexes (to reproduce, just comment out 'create index' command in my
> script).
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: jd@commandprompt.com, teodor@sigaev.ru, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us
Subject: Re: GiST notice
In-Reply-To: <42CC057A.9060105@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox