From: Carlos Moreno <moreno_pg@mochima.com>
To: Rodrigo Gonzalez <rjgonzale@gmail.com>
Cc: Carlos Moreno <moreno_pg@mochima.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
Date: Wed, 28 Feb 2007 15:53:32 -0500
Message-ID: <45E5EBCC.7090206@mochima.com> (raw)
In-Reply-To: <45E5E419.5050804@gmail.com>
References: <45E5B7D2.5020306@mochima.com>
<5279.1172683250@sss.pgh.pa.us>
<45E5D9D7.5090608@mochima.com>
<45E5E419.5050804@gmail.com>
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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: moreno_pg@mochima.com, rjgonzale@gmail.com
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
In-Reply-To: <45E5EBCC.7090206@mochima.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox