Re: [HACKERS] tables > 1 gig - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] tables > 1 gig
Date
Msg-id 199906180532.BAA17134@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] tables > 1 gig  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: [HACKERS] tables > 1 gig
List pgsql-hackers
> > Yes, I can see your point.  It would show them different views of the
> > table.
> >
> > So, as you were saying, we have no way of invalidating file descriptors
> > of other backends for secondary segments.
> 
> It seems DROP TABLE has a similar problem.
> It has been already solved ?

Not solved.  Someone reported it recently.

> 
> > Why does truncating the file
> > not work?  Any ideas?
> >
> 
> I have gotten no bug reports for my trial implementation.
> AFAIK,only Ole Gjerde has tested my patch.
> Is it sufficient ?

Yes.  We need something, and maybe after we add it, people can do
testing and find any problems.  It is better to apply it than to leave
it as it currently exists, no?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] tables > 1 gig
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] tables > 1 gig