DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=mnQDl7o/qcTAT24NCYx6ImM1mYR3HS0IJ/eiThfTl/1xdJTKwShz5/Q9yuK/8Z+4zX65ATMTeY6Z11CMJDicIKwTUFurPDgABFjlof1iF85Ed6yRJil1jT7MdkXbSoaXEmN1uf076OvVB//aebkcDsvm773aBmDfky0HezYdeFQ=
Message-ID: <45E5E419.5050804@gmail.com>
Date: Wed, 28 Feb 2007 17:20:41 -0300
From: Rodrigo Gonzalez <rjgonzale@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: Carlos Moreno <moreno_pg@mochima.com>
CC: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Upgraded to 8.2.3 --- still having performance issues
References: <45E5B7D2.5020306@mochima.com> <5279.1172683250@sss.pgh.pa.us>
	<45E5D9D7.5090608@mochima.com>
In-Reply-To: <45E5D9D7.5090608@mochima.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Carlos Moreno wrote:
> Tom Lane wrote:
> 
>> Carlos Moreno <moreno_pg@mochima.com> writes:
>>  
>>
>>> I would have expected a mind-blowing increase in responsiveness and
>>> overall performance.  However, that's not the case --- if I didn't know
>>> better, I'd probably tend to say that it is indeed the opposite  
>>> (performance seems to have deteriorated)
>>>   
>>
>> Did you remember to re-ANALYZE everything after loading up the new
>> database?  That's a frequent gotcha ...
>>  
>>
> 
> I had done it, even though I was under the impression that it wouldn't be
> necessary with 8.2.x  (I still chose to do it just in case).
> 
> 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.
> 
> Thanks,
> 
> Carlos
> -- 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

And the problem that *may* be related is....?

All the information is required so someone can give you good information...