Skip site navigation (1) Skip section navigation (2)

Re: What does a .1 suffix on a PG data file signify?

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: David Schnur <dnschnur(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What does a .1 suffix on a PG data file signify?
Date: 2012-05-16 18:56:52
Message-ID: 20120516185652.GI17908@aart.rice.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: francescoboccacci@libero.itDate: 2012-05-17 14:39:41
Subject: Run external program from postgresql
Previous:From: David SchnurDate: 2012-05-16 18:52:44
Subject: What does a .1 suffix on a PG data file signify?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group