I've been running postgresql for quite a while now. And it's been
working with minimal errors, leaving me in a fat, dumb and happy state.
Recently though, I ran out of disk space on my 1 partition. Upon
investigation, it appears that one of my databases was to blame. But
here's the odd part:

[base/cm]>ls -l

-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.0
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.1
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.2
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.3
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.4
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.5
-rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.6
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.0
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.1
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.2
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.3
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.4
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.5
-rw------- 1 postgres postgres 0 May 28 2000
pg_sorttemp32606.6
-rw------- 1 postgres postgres 115482624 Dec 18 23:46
pg_sorttemp3946.0
-rw------- 1 postgres postgres 109785088 Dec 18 23:46
pg_sorttemp3946.1
-rw------- 1 postgres postgres 100233216 Dec 18 23:46
pg_sorttemp3946.2
-rw------- 1 postgres postgres 86548480 Dec 18 23:46 pg_sorttemp3946.3
-rw------- 1 postgres postgres 63303680 Dec 18 23:46 pg_sorttemp3946.4
-rw------- 1 postgres postgres 43204608 Dec 18 23:46 pg_sorttemp3946.5
-rw------- 1 postgres postgres 0 Dec 19 09:37 pg_sorttemp3946.6

My questions:
What are these files?
Are they safe to delete?


Thanks for any input

-Rob

Search Discussions

  • Stephan Szabo at Dec 20, 2000 at 5:30 pm
    Those are temporary files used for sorting. It was a probably a cleanup
    problem on 6.5 (perhaps the query aborted or something leaving the files?
    not sure). As long as you know that the process is still not using them
    they should be safe to delete. (And you should probably update to 7.1
    when it comes out :) )

    Stephan Szabo
    sszabo@bigpanda.com
    On Wed, 20 Dec 2000, Robert Dege wrote:

    I've been running postgresql for quite a while now. And it's been
    working with minimal errors, leaving me in a fat, dumb and happy state.
    Recently though, I ran out of disk space on my 1 partition. Upon
    investigation, it appears that one of my databases was to blame. But
    here's the odd part:

    [base/cm]>ls -l

    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.0
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.1
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.2
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.3
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.4
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.5
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.6
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.0
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.1
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.2
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.3
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.4
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.5
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.6
    -rw------- 1 postgres postgres 115482624 Dec 18 23:46
    pg_sorttemp3946.0
    -rw------- 1 postgres postgres 109785088 Dec 18 23:46
    pg_sorttemp3946.1
    -rw------- 1 postgres postgres 100233216 Dec 18 23:46
    pg_sorttemp3946.2
    -rw------- 1 postgres postgres 86548480 Dec 18 23:46 pg_sorttemp3946.3
    -rw------- 1 postgres postgres 63303680 Dec 18 23:46 pg_sorttemp3946.4
    -rw------- 1 postgres postgres 43204608 Dec 18 23:46 pg_sorttemp3946.5
    -rw------- 1 postgres postgres 0 Dec 19 09:37 pg_sorttemp3946.6

    My questions:
    What are these files?
    Are they safe to delete?


    Thanks for any input

    -Rob
  • Webb Sprague at Dec 20, 2000 at 5:47 pm
    How close are the two languages? I am especially interested because I
    have thought about getting a book on PLSQL (Oracle) and practicing on
    Postgres.

    Thanks
    Webb
  • Robert Dege at Dec 20, 2000 at 6:02 pm
    I figured that they were temp files. I was intruiged to see it use the
    local directory instead of /tmp though.

    Upgrading to 7.1 will be quite a task since the server is heavily used
    by the company, but a project is in the works.

    Thanks for the advice. I just wanted to re-assure my assumptions before
    taking any action.

    -Rob

    Those are temporary files used for sorting. It was a probably a cleanup
    problem on 6.5 (perhaps the query aborted or something leaving the files?
    not sure). As long as you know that the process is still not using them
    they should be safe to delete. (And you should probably update to 7.1
    when it comes out :) )

    Stephan Szabo
    sszabo@bigpanda.com
    On Wed, 20 Dec 2000, Robert Dege wrote:

    I've been running postgresql for quite a while now. And it's been
    working with minimal errors, leaving me in a fat, dumb and happy state.
    Recently though, I ran out of disk space on my 1 partition. Upon
    investigation, it appears that one of my databases was to blame. But
    here's the odd part:

    [base/cm]>ls -l

    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.0
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.1
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.2
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.3
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.4
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.5
    -rw------- 1 postgres postgres 0 May 28 2000 pg_sorttemp2662.6
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.0
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.1
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.2
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.3
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.4
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.5
    -rw------- 1 postgres postgres 0 May 28 2000
    pg_sorttemp32606.6
    -rw------- 1 postgres postgres 115482624 Dec 18 23:46
    pg_sorttemp3946.0
    -rw------- 1 postgres postgres 109785088 Dec 18 23:46
    pg_sorttemp3946.1
    -rw------- 1 postgres postgres 100233216 Dec 18 23:46
    pg_sorttemp3946.2
    -rw------- 1 postgres postgres 86548480 Dec 18 23:46 pg_sorttemp3946.3
    -rw------- 1 postgres postgres 63303680 Dec 18 23:46 pg_sorttemp3946.4
    -rw------- 1 postgres postgres 43204608 Dec 18 23:46 pg_sorttemp3946.5
    -rw------- 1 postgres postgres 0 Dec 19 09:37 pg_sorttemp3946.6

    My questions:
    What are these files?
    Are they safe to delete?


    Thanks for any input

    -Rob

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedDec 20, '00 at 4:58p
activeDec 20, '00 at 6:02p
posts4
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase