[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Subject: What does a .1 suffix on a PG data file signify?
From: David Schnur <dnschnur@xxxxxxxxx>
Date: Wed, 16 May 2012 14:52:44 -0400
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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

Follow-Ups:
- Re: What does a .1 suffix on a PG data file signify?
  - From: ktm@xxxxxxxx

Prev by Date: Re: dangling connections
Next by Date: Re: What does a .1 suffix on a PG data file signify?
Previous by thread: Monitoring for failed autovacuum
Next by thread: Re: What does a .1 suffix on a PG data file signify?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]