Обсуждение: Is the fix for > 2GB files already in 6.5.3?

Hello Everyone,

I want to build a prototype system under 32-bit Linux using
a table that would be about 20GB with PostgreSQL. I looked
through the archives and saw talk about a patch for PostgreSQL
to fix a bug with tables > 2Gb. If the system worked, I would
like to migrate over to a 64-bit Alpha system and have tables
> 40GB. Will it work?

Is this patch incorporated into the latest release?

Regards,

Ron King

> Hello Everyone,
>
> I want to build a prototype system under 32-bit Linux using
> a table that would be about 20GB with PostgreSQL. I looked
> through the archives and saw talk about a patch for PostgreSQL
> to fix a bug with tables > 2Gb. If the system worked, I would
> like to migrate over to a 64-bit Alpha system and have tables
> > 40GB. Will it work?
>
> Is this patch incorporated into the latest release?

Yes, they are all in 6.5.*.

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

On Mon, 24 Jan 2000, Ron King wrote:

> Hello Everyone,
>
> I want to build a prototype system under 32-bit Linux using
> a table that would be about 20GB with PostgreSQL. I looked
> through the archives and saw talk about a patch for PostgreSQL
> to fix a bug with tables > 2Gb. If the system worked, I would
> like to migrate over to a 64-bit Alpha system and have tables
> > 40GB. Will it work?
>
> Is this patch incorporated into the latest release?

It should be as it went in before 6.5.3. The main fix was to break the
table files into 1Gb blocks.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf