Re: [HACKERS] tables > 1 gig

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] tables > 1 gig
Date: 1999-06-18 05:32:27
Message-ID: 199906180532.BAA17134@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 1999-06-18 06:11:19 RE: [HACKERS] tables > 1 gig
Previous Message Hiroshi Inoue 1999-06-18 05:27:01 RE: [HACKERS] tables > 1 gig