From: | gjerde(at)icebox(dot)org |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Problems with >2GB tables on Linux 2.0 |
Date: | 1999-02-05 23:07:38 |
Message-ID: | Pine.LNX.4.05.9902051656370.32234-100000@snowman.icebox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I saw a message a couple of weeks ago from someone having problems with
larger than 2GB tables. I have similar problems.
PostgreSQL: anon-cvs as of today (2/5/1999)
OS: Redhat Linux 5.2 (running 2.0.35)
I created a database called mcrl, and a table called mcrl3_1.
I copied in a set of 450MB of data twice(which comes to pg file size of
2.4GB or so).
When it hit 2GB I got this message:
mcrl=> copy mcrl3_1 FROM '/home/gjerde/mcrl/MCR3_1.txt';
ERROR: mcrl3_1: cannot extend
The table file looks like this:
[postgres(at)snowman mcrl]$ ls -l mcrl*
-rw------- 1 postgres postgres 2147482624 Feb 5 16:49 mcrl3_1
It did NOT create the .1 file however, which I did see when I tried this
on 6.4.2(but still didn't work).
I looked around in the code(specifically src/backend/storage/smgr/*.c),
but couldn't figure too much of it out. I'll have to figure out how
postgres handles the database files first..
Hope this helps,
Ole Gjerde
From | Date | Subject | |
---|---|---|---|
Next Message | gjerde | 1999-02-06 02:27:08 | Ignore me :) Re: [HACKERS] Problems with >2GB tables on Linux 2.0 |
Previous Message | Bruce Momjian | 1999-02-05 22:23:42 | Re: [HACKERS] Optimizer speed and GEQO (was: nested loops in joins) |