Re: What is a foo.1 file?

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/