From: ktm@rice.edu <ktm@rice.edu>
To: David Schnur <dnschnur@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: What does a .1 suffix on a PG data file signify?
Date: Wed, 16 May 2012 13:56:52 -0500
Message-ID: <20120516185652.GI17908@aart.rice.edu> (raw)
In-Reply-To: <CAANiQEng+iQCkFQ7mwzyu-sS0MKekA__Hn=aVmJMgnTwfvTb+w@mail.gmail.com>
References: <CAANiQEng+iQCkFQ7mwzyu-sS0MKekA__Hn=aVmJMgnTwfvTb+w@mail.gmail.com>
On Wed, May 16, 2012 at 02:52:44PM -0400, David Schnur wrote:
> I'm investigating a 'could not stat file' error that points to a file
> "base/16384/52212305.1". All the data files I've ever seen have names that
> are whole numbers; I've never seen a decimal suffix. It occurs to me that
> perhaps this is some kind of temp-file, or a system for avoiding duplicate
> file names, both of which might be relevant in the context of this error.
>
> Can anyone confirm what the presence of the .1 suffix means?
>
> I'm using Postgres 8.3.15 on Windows.
>
> Thanks,
>
> David
Hi David,
Once you exceed the first 1GB of data for a file, a new file is
created with a .1 appended for the 2nd GB, and so on. For small
databases, you may never see a .1,.2,...
Regards,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, dnschnur@gmail.com
Subject: Re: What does a .1 suffix on a PG data file signify?
In-Reply-To: <20120516185652.GI17908@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox