Postgres Pro
Downloads
Home   >   mailing lists

Thread: what does this mean - pg_psort.1922.0 in database directory?

what does this mean - pg_psort.1922.0 in database directory?

From
"Natalya S. Makushina"
Date:
Hi all!

I found strange files in my database directory.

ls /usr/local/pgsql/base/isrts/pg_psort.1922.* -l
-rw-------   1 postgres postgres 564108288 Oct  1 17:37 /usr/local/pgsql/base/isrts/pg_psort.1922.0
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.1
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.2
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.3
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.4
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.5
-rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.6

What does it mean?
Any ideas?

                Best regards, Natalia Makushina.

Re: [GENERAL] what does this mean - pg_psort.1922.0 in database directory?

From
Karl DeBisschop
Date:
These are temporary files created by sorting - as long as you're sure
that there are no active sorts, you can safely delete them all (or we
have done so at least).

I believe this is covered in the FAQ.

--
Karl DeBisschop <kdebisschop@alert.infoplease.com>
617.832.0332 (Fax: 617.956.2696)

Information Please - your source for FREE online reference
http://www.infoplease.com  - Your Ultimate Fact Finder
http://kids.infoplease.com - The Great Homework Helper

Re: [GENERAL] what does this mean - pg_psort.1922.0 in database directory?]

From
Bruce Momjian
Date:
> Hi all!
>
> I found strange files in my database directory.
>
> ls /usr/local/pgsql/base/isrts/pg_psort.1922.* -l
> -rw-------   1 postgres postgres 564108288 Oct  1 17:37 /usr/local/pgsql/base/isrts/pg_psort.1922.0
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.1
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.2
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.3
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.4
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.5
> -rw-------   1 postgres postgres        0 Oct  1 16:57 /usr/local/pgsql/base/isrts/pg_psort.1922.6
>
> What does it mean?
> Any ideas?

They are sort files that somehow did not get cleaned up.  If nothing is
running, you can remove them.  See FAQ item.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026