Lists: | pgsql-general |
---|
From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Naming-scheme for db-files |
Date: | 2002-08-28 13:54:45 |
Message-ID: | 2266D0630E43BB4290742247C891057501B13322@dozer.computec.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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...
Regards,
Markus
From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Markus Wollny <Markus(dot)Wollny(at)computec(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Naming-scheme for db-files |
Date: | 2002-08-28 14:30:17 |
Message-ID: | 20020829003017.C27041@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(at)svana(dot)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.