Re: Cleaning up unreferenced table files

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Cleaning up unreferenced table files
Date: 2005-04-26 22:18:12
Message-ID: Pine.OSF.4.61.0504270109540.521717@kosh.hut.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Tue, 26 Apr 2005, Heikki Linnakangas wrote:

> On Mon, 25 Apr 2005, Bruce Momjian wrote:
...
>> I guess I am happy with just reporting during startup like the patch
>> does now.
>
> Ok. I'll fix the design issues Tom addressed earlier, add documentation, and
> resubmit.

Here you go.

The new functionality is now separated in a new file
backend/utils/init/cleanup.c.

There was code in many places that constructs the path to a tablespace
directory. I refactored that into a new function called GetTablespacePath
and put it next to GetDatabasePath in catalog.c.

I added a section under the "Routine Database Maintenance Tasks" that
basically gives a heads up that these notifications can appear in the log
after a crash.

- Heikki

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message John DeSoi 2005-04-27 00:02:30 Re: [HACKERS] Continue transactions after errors in psql
Previous Message Tom Lane 2005-04-26 15:51:38 Re: [HACKERS] Continue transactions after errors in psql