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@reptiles.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 ]