Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group