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
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 |