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: | Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>, "''Merlin Moncure' '" <merlin(dot)moncure(at)rcsonline(dot)com>, "'pgsql-hackers-win32 '" <pgsql-hackers-win32(at)postgresql(dot)org>, "'PostgreSQL-development '" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: What's left? |
Date: | 2004-01-26 05:13:53 |
Message-ID: | 200401260513.i0Q5Dra23724@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-hackers-win32 |
Tom Lane wrote:
> Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com> writes:
> > One important thing I forgot, that someone could start looking at now:
> > * backends keeping files open when other backends are trying to
> > delete/rename them
>
> > We must do better for the official port,
>
> Why? The procedure you mentioned seems perfectly adequate to me,
> seeing that it's a bit of a corner case to start with.
I don't see this as a corner case, except it being a corner case
operating system. :-)
I think it will very likely rename/unlink will fail because of the file
descriptor cache kept by each backend.
I am attaching dir.c from the PeerDirect port. It handles unlink
failures by appending the failed file name to a file that is later read
and another unlink attempted. Perhaps this is something we can do, and
have try unlinks after each checkpoint.
PeerDirect handles rename by just looping. We really can't delay a
rename. There is discussion in the Win32 TODO detail that goes over
some options, I think.
--
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
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 7.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-26 05:26:24 | Re: What's left? |
Previous Message | Dennis Bjorklund | 2004-01-26 05:10:59 | Re: Named arguments in function calls |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-26 05:26:24 | Re: What's left? |
Previous Message | Bruce Momjian | 2004-01-26 02:07:41 | Re: [pgsql-hackers-win32] What's left? |