Re: [HACKERS] Problems with >2GB tables on Linux 2.0

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: peter(at)retep(dot)org(dot)uk (Peter T Mount)
Cc: gjerde(at)icebox(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Date: 1999-02-08 15:16:40
Message-ID: 199902081516.KAA14338@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Not sure. My original choice was to subtract 1 from the calculated
> maximum, which meant it would split just before the 2Gb limit.
>
> However, running with the value set at the lower value:
>
> 1998585856 Feb 8 02:25 /opt/db/base/test/smallcat
> 599007232 Feb 8 03:21 /opt/db/base/test/smallcat.1
>
> Total 26653000 rows loaded
>
> Would anyone really notice the lower value?
>
> Perhaps we could make this another compile time setting, like the block
> size?

I guess all I am saying is I prefer the max-1 value. Seems more
logical. Could be set in config.h.in, though.

--
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 Bruce Momjian 1999-02-08 15:20:08 Re: [HACKERS] trouble with rules
Previous Message Nick Bastin 1999-02-08 15:06:12 Re: Commercial support, was Re: [HACKERS] v6.4.3 ?