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
>