Re: Crash while recovering database index relation

From: Guy Thornley <guy(at)esphion(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Crash while recovering database index relation
Date: 2004-01-08 22:01:15
Message-ID: 20040108220115.GC27470@conker.esphion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> > What I don't grok is why all the affected files were indexes, and none
> > of the heap files appeared to have junk pages
>
> Hmmm ... that is mildly interesting, but it doesn't rise to the level of
> warning bells in my head.

I played around a bit yesterday with an INSERT'ing shell script and a reset
button... I can now, with reasonable confidence, say was pure coincidence
they were all index files. I had the junk pages in normal heap files as well
as index files on several occasions while testing

> Were the indexes involved all on the same table, or different tables?
Different tables, which is what aroused my own curosity :)

Guy

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-01-09 00:16:06 Re: Fwd: Bug#224716: postgresql-client: createuser fails
Previous Message Tom Lane 2004-01-08 21:41:19 Re: character varying array bug in 7.4.1