pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat does a .1 suffix on a PG data file signify?
2+ messages / 2 participants
[nested] [flat]
* What does a .1 suffix on a PG data file signify?
@ 2012-05-16 18:52 David Schnur <dnschnur@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: David Schnur @ 2012-05-16 18:52 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: What does a .1 suffix on a PG data file signify?
@ 2012-05-16 18:56 ktm@rice.edu <ktm@rice.edu>
parent: David Schnur <dnschnur@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: ktm@rice.edu @ 2012-05-16 18:56 UTC (permalink / raw)
To: David Schnur <dnschnur@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-05-16 18:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-16 18:52 What does a .1 suffix on a PG data file signify? David Schnur <dnschnur@gmail.com>
2012-05-16 18:56 ` ktm@rice.edu <ktm@rice.edu>
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