Re: Remove sort 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: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Remove sort files
Date: 2001-05-23 19:46:34
Message-ID: 200105231946.f4NJkYN07917@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Anyway, I am still thinking about this. I haven't addressed tables that
> > are orphaned by a rename aborting.
> >>
> >> What makes you think that needs to be addressed? We don't have that
> >> problem anymore AFAIK.
>
> > If one backend creates a new file for alter table, but crashes before
> > modifying pg_class, doesn't that file just hang around?
>
> ALTER TABLE doesn't create any new files.

What about CLUSTER? If we do DROP COLUMN by creating a new heap, we
will use it then too, right? Are those the only two that create new
files that could be orphaned?

Now that we have file numbers, seems we can do DROP COLUMN now reliably,
right?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-05-23 19:57:47 Re: Remove sort files
Previous Message Bruce Momjian 2001-05-23 19:40:50 Re: Remove sort files