From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Ole Gjerde" <gjerde(at)icebox(dot)org>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] Current TODO list |
Date: | 1999-05-24 04:46:21 |
Message-ID: | 000f01bea5a0$5e900600$2801007e@cadzone.tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Bruce Momjian [mailto:maillist(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Monday, May 24, 1999 12:32 PM
> To: Hiroshi Inoue
> Cc: Ole Gjerde; PostgreSQL-development
> Subject: Re: [HACKERS] Current TODO list
>
>
> > > I don't think unlink() is a problem. That other backends
> have the files
> > > open shouldn't matter. Whenever they close it(should be
> pretty quick),
> >
> > When are those files closed ?
> > AFAIC,they are kept open until the backends which reference those files
> > finish.
> >
> > Certainly,those files are re-opened(without closing) by backends after
> > vacuum,though I don't know it's intentional or caused by side-effect.
> > But unfortunately,re-open is not sufficiently quick.
> >
> > And I think that the assumption of mdtruncate() is not clear.
> > Could we suppose that unlinked files are closed quickly for all
> backends
> > by the caller of mdunlink() ?
>
> If they try and open a file that is already unlinked, they don't get to
> see the file. Unlink removes it from the directory, so the only way to
> continue access after an unlink is if you already hold a file descrpitor
> on the file.
>
You are right.
Backends would continue to access the file descritors already hold
if vacuum does nothing about the invalidation of Relation Cache.
Thanks.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1999-05-24 05:17:53 | Re: [HACKERS] strange behavior of UPDATE |
Previous Message | Tatsuo Ishii | 1999-05-24 04:10:37 | Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction |