Re: files ending with .1 or .2 - Mailing list pgsql-general

From Arjen van der Meijden
Subject Re: files ending with .1 or .2
Date
Msg-id 41761D5A.7090405@vulcanus.its.tudelft.nl
Whole thread Raw
In response to files ending with .1 or .2  (Leonardo Francalanci <lfrancalanci@simtel.ie>)
Responses Re: files ending with .1 or .2  (Leonardo Francalanci <lfrancalanci@simtel.ie>)
List pgsql-general
When a data file for a specific table (or index?) is larger than 1GB,
its split up in several parts. This is probably a left over from the
time OSs used to have problems with large files.

The file name, that number, is the OID of the table afaik. And the
postfix is of course the number in the order of parts.

Best regards,

Arjen

On 20-10-2004 9:39, Leonardo Francalanci wrote:
> I got a table with oid 25459.
> The file is 1073741824 bytes big.
> I did some more inserts, and now I have this two new files:
>
> size/name:
>
> 1073741824 25459.1
> 21053440 25459.2
>
>
> What are they?
> The 25459.1 looks exactly like the 25459.
>
> I tried looking at the docs, but searching for ".1" or ".2" wasn't that
> helpful...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: SQL update function faililed in Webmin Interface
Next
From: Leonardo Francalanci
Date:
Subject: Re: files ending with .1 or .2