Обсуждение: 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