| From: | Arjen van der Meijden <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> |
|---|---|
| To: | Leonardo Francalanci <lfrancalanci(at)simtel(dot)ie> |
| Cc: | postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: files ending with .1 or .2 |
| Date: | 2004-10-20 08:10:02 |
| Message-ID: | 41761D5A.7090405@vulcanus.its.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leonardo Francalanci | 2004-10-20 08:14:06 | Re: files ending with .1 or .2 |
| Previous Message | Scott Marlowe | 2004-10-20 07:49:09 | Re: SQL update function faililed in Webmin Interface |