Re: Bug in new buffering GiST build code - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in new buffering GiST build code
Date
Msg-id 29091.1338442850@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in new buffering GiST build code  (Alexander Korotkov <aekorotkov@gmail.com>)
List pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes:
> I've one note not directly related to buffering build. While I debugging
> buffering GiST index build, backend was frequently crashed. After recovery
> partially built index file was remain. Do we have some tool to detect such
> "dead" files? If not, probably we need some?

Well, it's not that hard to check for orphan files (I think
contrib/oid2name can do that, or perhaps could be extended to).  I don't
like the idea of the postmaster automatically removing such files, if
that's where you were headed.  Too much risk of deleting important data.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [PERFORM] pg_dump and thousands of schemas
Next
From: Tom Lane
Date:
Subject: Re: remembering locks and dynahash.c