From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | 2 gig limitation? |
Date: | 1999-04-29 12:48:06 |
Message-ID: | m10cqEY-000818C@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
i've noticed that one of our databases looks a bit strange:
-rw------- 1 pgsql pgsql 2147483648 Apr 28 23:06 gt
-rw------- 1 pgsql pgsql 171073536 Apr 29 08:28 gt.1
is there some strange thing that happens when a database exceeds 2 gig in size?
i have a nightly process which selects the previous 30 days data into a
new table, then does a:
alter table rename gt to gt_old;
alter table rename gt_new to gt;
create unique index gt_index on some_field;
the create index failed.
--
[ Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail. ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Good | 1999-04-29 12:55:18 | Re: [GENERAL] UnixWare chokes --- Resolution |
Previous Message | Thomas Good | 1999-04-29 12:31:32 | Re: [GENERAL] Desperately Seeking Regular Expression (fwd) |