| [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] |
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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]