From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | David Huttleston Jr <dhjr(at)hddesign(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: What is a foo.1 file? |
Date: | 2000-10-06 14:17:18 |
Message-ID: | Pine.LNX.4.21.0010061615420.949-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
David Huttleston Jr writes:
> The file tbl_voters_full.1 is new to me, and it does contain data.
> Is this a temporary table? Is it safely deletable?
>
> ** snipped from a ls of /home/postgres/data/base/pacwebdev
> -rw------- 1 postgres postgres 1073741824 Oct 4 23:53 tbl_voters_full
> -rw------- 1 postgres postgres 144687104 Oct 5 00:09 tbl_voters_full.1
The table "tbl_voters" exceeded 1 GB in size and was thus split up into
two physical files. You will get .2, .3, etc. each time you grow another
GB.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-10-06 14:19:59 | Re: ssh problem ? |
Previous Message | Frederick W. Reimer | 2000-10-06 14:08:16 | RE: Any experiencies of PG 7.0.2 on OS/2 Warp? |