Re: What is a foo.1 file? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: What is a foo.1 file?
Date
Msg-id Pine.LNX.4.21.0010061615420.949-100000@peter.localdomain
Whole thread Raw
In response to What is a foo.1 file?  (David Huttleston Jr <dhjr@hddesign.com>)
List 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@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: "Frederick W. Reimer"
Date:
Subject: RE: Any experiencies of PG 7.0.2 on OS/2 Warp?
Next
From: Peter Eisentraut
Date:
Subject: Re: ssh problem ?