General Bug Report: Files greater than 1 GB are created while sorting - Mailing list pgsql-bugs

From Unprivileged user
Subject General Bug Report: Files greater than 1 GB are created while sorting
Date
Msg-id 199907010457.AAA81618@hub.org
Whole thread Raw
Responses Re: [BUGS] General Bug Report: Files greater than 1 GB are created while sorting
Re: [BUGS] General Bug Report: Files greater than 1 GB are created while sorting
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Doug Mitchell
Your email address      : doug@mitchcraft.com

Category                : runtime: back-end
Severity                : serious

Summary: Files greater than 1 GB are created while sorting

System Configuration
--------------------
  Operating System   : Linux 2.2.5 ELF (RedHat 6.0)

  PostgreSQL version : 6.5

  Compiler used      : cc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)

Hardware:
---------
PII-300 with 384 MB RAM

Versions of other tools:
------------------------
$ rpm -q make flex
make-3.77-6
flex-2.5.4a-6


--------------------------------------------------------------------------

Problem Description:
--------------------

The backed is creating files bigger than 1 GB when sorting
and it will break when the file gets to 2 GB.

Here are the biggest files:

1049604 -rw-------   1 postgres postgres 1073741824 Jun 30 19:10 bigtable_pkey
1049604 -rw-------   1 postgres postgres 1073741824 Jun 30 19:36 pg_temp.2446.0
1049604 -rw-------   1 postgres postgres 1073741824 Jun 30 19:55 bigtable
1122136 -rw-------   1 postgres postgres 1147937412 Jun 30 21:39 pg_temp2769.3
1148484 -rw-------   1 postgres postgres 1174890288 Jun 30 21:26 pg_temp2769.4

I also have some smaller ".1" files that are the rest of the above
files along with everything else you might expect to find in a
PG database directory.  It's those two last big ones that are
troublesome.

Table and indicies are segmenting just fine at 1GB, but
some sort files just keep growing.  I did actually get a
back-end error one time when one exceeded 2 GB.

Thanks,
Doug


--------------------------------------------------------------------------

Test Case:
----------
Just do:
mydb=> select * into bigtable2 from bigtable order by custno;

You might want to decrease RELSEGSZ to see it faster.
Mail be back if you can't reproduce it.
(and please make the bug report form boxes bigger!)

--------------------------------------------------------------------------

Solution:
---------
Something is not using the Magnetic Disk Storage Manager,
but is writing a temp file out on its own during the sort.



--------------------------------------------------------------------------


pgsql-bugs by date:

Previous
From: Fomichev Michael
Date:
Subject: ...
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] General Bug Report: Files greater than 1 GB are created while sorting