Thread

1. Problem with duplicate file.

   (unknown) — 2003-06-25T13:32:26Z

   Hi,
   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 ?
   
   Best regards,
   
   Annie.
   
   ------------------------------------------
   
   Faites un voeu et puis Voila ! www.voila.fr 
   
   
   
   

2. Re: [BUGS] Problem with duplicate file.

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2003-06-27T22:43:14Z

   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@voila.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...
   
   
   

3. Re: [BUGS] Problem with duplicate file.

   Martijn van Oosterhout <kleptog@svana.org> — 2003-06-28T01:10:35Z

   On Fri, Jun 27, 2003 at 03:43:14PM -0700, Stephan Szabo wrote:
   > 
   > 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@voila.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...
   
   Correct, It just means the table exceeded 2GB.
   
   -- 
   Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
   > "the West won the world not by the superiority of its ideas or values or
   > religion but rather by its superiority in applying organized violence.
   > Westerners often forget this fact, non-Westerners never do."
   >   - Samuel P. Huntington