Re: [BUGS] Problem with duplicate file.

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: abremond(at)voila(dot)fr <abremond(at)voila(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [BUGS] Problem with duplicate file.
Date: 2003-06-27 22:43:14
Message-ID: 20030627153831.Q76283-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general


I don't see anything in this that's a bug report, so I'm redirecting to
-general.

On Wed, 25 Jun 2003, [utf-8] abremond(at)voila(dot)fr wrote:

> I work with a database PostgreSQL 7.3.1 on Linux.
>
> I observe that the size of my database is bigger and when I verify the
> size for each file on the database directory, I remark that one of
> this files (16404) is duplicate in two files : 16404.1 and 16404.2.
> Moreover, the files 16404 and 16404.1 have the same size (1 Giga)
> I don't understand why the file (16404) is duplicate in two another
> files 16404.1 and 16404.2.
> I don't undertand this architecture. Could you give me an explication ?

IIRC, some systems have trouble with large files, PostgreSQL breaks the
data for tables at one gigabyte boundaries. So 16404 is the first gig,
16404.1 is the second, etc...

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-06-28 01:10:35 Re: [BUGS] Problem with duplicate file.
Previous Message Tom Lane 2003-06-27 14:56:08 Re: DBCP borrowObject failed

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-06-27 22:58:08 Re: Redhat's "enhancements" to PG
Previous Message The Hermit Hacker 2003-06-27 22:35:50 Re: Redhat's "enhancements" to PG