Thus spake Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
BTW, if you are seeing unreclaimed sorttemp files in a recent release
(7.0 or later), I'd like to know about it. That shouldn't happen,
short of a backend crash anyway...
Well, I had over 6,000 of these files.
Thus spake Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
BTW, if you are seeing unreclaimed sorttemp files in a recent release
(7.0 or later), I'd like to know about it. That shouldn't happen,
short of a backend crash anyway...
Well, I had over 6,000 of these files. This
Thus spake Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
I have tons of old files with names like base/db/pg_sorttemp.##. I
assume that they are temporary sorting files but somehow they never got
cleared out. Is it safe to delete these from a running system. The files
are
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
BTW, if you are seeing unreclaimed sorttemp files in a recent release
(7.0 or later), I'd like to know about it. That shouldn't happen,
short of a backend crash anyway...
Well, I had over 6,000 of these files. This database is about a year old.
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
I have tons of old files with names like base/db/pg_sorttemp.##. I
assume that they are temporary sorting files but somehow they never got
cleared out. Is it safe to delete these from a running system. The files
are months old.
The first
I have tons of old files with names like base/db/pg_sorttemp.##. I
assume that they are temporary sorting files but somehow they never got
cleared out. Is it safe to delete these from a running system. The files
are months old.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is
My guess is probably yes it's ok - just shut down the server before deleting
them!
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of D'Arcy J.M. Cain
Sent: Thursday, 18 October 2001 3:46 AM
To: [EMAIL PROTECTED]
Subject: [HACKERS] pg_sorttemp