Re: [SQL] So what happens at 2GB?

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: [SQL] So what happens at 2GB?
Дата
Msg-id Pine.LNX.4.04.9903131529440.4823-100000@dragosani.lan2wan.com
обсуждение исходный текст
Ответ на Re: [SQL] So what happens at 2GB?  (Karl Denninger <karl@Denninger.Net>)
Список pgsql-sql
On Sat, 13 Mar 1999, Karl Denninger wrote:

> > > No.  It works properly.  I have had tables exceeding 10GB.
> >
> > How does it get past an operating system limitation on file size?
> >
> > Brett W. McCoy
> >                                         http://www.lan2wan.com/~bmccoy/
>
> There isn't one on FreeBSD, but Postgres doesn't seem to know that.
> Instead, it breaks the table up into 2G-sized file chunks.

It may do that for performance reasons, I would guess, or for
compatibility with other operating systems that have the limitation (like
Linux).

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
We are what we pretend to be.
        -- Kurt Vonnegut, Jr.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------


В списке pgsql-sql по дате отправления:

Предыдущее
От: Karl Denninger
Дата:
Сообщение: Re: [SQL] So what happens at 2GB?
Следующее
От: "Tim Perdue"
Дата:
Сообщение: URGENT - "CANNOT EXTEND"