Skip site navigation (1) Skip section navigation (2)

Re: Upgraded to 8.2.3 --- still having performance issues

From: Carlos Moreno <moreno_pg(at)mochima(dot)com>
To: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
Cc: Carlos Moreno <moreno_pg(at)mochima(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
Date: 2007-02-28 20:53:32
Message-ID: 45E5EBCC.7090206@mochima.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
--


In response to

Responses

pgsql-performance by date

Next:From: Carlos MorenoDate: 2007-02-28 21:33:23
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
Previous:From: Rodrigo GonzalezDate: 2007-02-28 20:20:41
Subject: Re: Upgraded to 8.2.3 --- still having performance issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group