| Lists: | pgsql-bugspgsql-general |
|---|
| From: | abremond(at)voila(dot)fr <abremond(at)voila(dot)fr> |
|---|---|
| To: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Problem with duplicate file. |
| Date: | 2003-06-25 13:32:26 |
| Message-ID: | HH1HM2$B4A6BD3F2B902C628F79645F18250970@voila.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-general |
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
| 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 |
| 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...
| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | "abremond(at)voila(dot)fr" <abremond(at)voila(dot)fr>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [BUGS] Problem with duplicate file. |
| Date: | 2003-06-28 01:10:35 |
| Message-ID: | 20030628011032.GA27979@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-general |
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(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...
Correct, It just means the table exceeded 2GB.
--
Martijn van Oosterhout <kleptog(at)svana(dot)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