Rodrigo Gonzalez wrote:
>
>> I've since discovered a problem that *may* be related to the
>> deterioration
>> of the performance *now* --- but that still does not explain the machine
>> choking since last night, so any comments or tips are still most
>> welcome.
>> [...]
>>
> And the problem that *may* be related is....?
>
> All the information is required so someone can give you good
> information...
You are absolutely right, of course --- it was an instance of "making a
long
story short" for everyone's benefit :-)
To make the story as short as possible: I was running a program that does
clean up on the database (move records older than 60 days). That program
creates log files, and it exhausted the available space on the /home
partition
(don't ask! :-)).
The thing is, all of postgres's data is below the /var partition (which
has a
total of 200GB, and still around 150GB available) --- in particular, the
postgres' home directory is /var/users/postgres, and the database cluster's
data directory is /var/users/postgres/data --- that tells me that this
issue with
the /home partition should not make postgres itself choke; the clean up
program was totally choking, of course.
And yes, after realizing that, I moved the cleanup program to some place
below the /var directory, and /home now has 3.5GB available.
Thanks,
Carlos
--