Re: Naming-scheme for db-files

On Wed, Aug 28, 2002 at 03:54:45PM +0200, Markus Wollny wrote:
> Hi!
>
> As I was just checking disk-usage of a database (PostgreSQL 7.2.1), I
> stumbled over some files named with a trailing .1 added to the usual
> oid. Now if a table 'example' with oid 12345 exists, what does the file
> 12345.1 contain exactly? I didn't find anything about .1-files in the
> documentation...

Postgres splits files at 1GB. The .1 file would be the second part of the
file. When that also reaches 1GB, you'll get a .2 file.

You're doing VACUUM [FULL] regularly, right?

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.