Re: Cleaning up unreferenced table files

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Cleaning up unreferenced table files
Date: 2005-04-27 17:13:11
Message-ID: 200504271713.j3RHDBE19110@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Tom Lane wrote:
> Heikki Linnakangas <hlinnaka(at)iki(dot)fi> writes:
> > On Tue, 26 Apr 2005, Tom Lane wrote:
> >> Heikki Linnakangas <hlinnaka(at)iki(dot)fi> writes:
> >>> I feel that crashes that leaves behind stale files are rare.
> >>
> >> Indeed, and getting more so all the time ...
>
> > How so? Have changes been made in those parts of the code?
>
> No, just that the overall reliability of Postgres keeps improving.
>
> At the time that TODO entry was created, I don't think we even had the
> ability to roll back table creates/drops properly, so there were
> scenarios in which unreferenced files could be left behind without even
> assuming any software error. And the prevalence of backend crashes was
> way higher than it is now, too. So I think a good argument could be
> made that the TODO item isn't nearly as important as it was at the time.
>
> > If nobody ever runs into this issue in production, and this whole exercise
> > turns out to be completely unnecessary, at least we'll know. That alone
> > makes me feel better.
>
> We will know no such thing, unless the patch is made to announce the
> problem so intrusively that people are certain to see it *and report it
> to us*. Which I don't think will be acceptable.

Well, if putting it in the server logs isn't enough, I don't know what
is.

I think we do need the patch, at least to find out if there is an issue
we don't know about. I don't see the hard in it.

Heikki, would you time startup and tell us what percentage of time is
taken by the routines? Or I can do it.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-04-27 17:16:40 Re: [HACKERS] Continue transactions after errors in psql
Previous Message Bruce Momjian 2005-04-27 16:39:44 Re: [HACKERS] Continue transactions after errors in psql