Re: Performance problem from migrating between versions!

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problem from migrating between versions!
Date: 2005-01-17 18:57:10
Message-ID: 41EC0A86.5090001@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:

>I wouldn't recommend turning off hashagg as a permanent solution, it
>was just a quickie to verify my suspicion of where the memory was going.
>
>
>

Hi,

How to understant the upper sentence? I shouldn't turn "hashagg" off
permanently for this query or for the entire database. For now I turn it
off for this query, so it can work. If I shouldn't, then what should I
do? Will ANALYZE resove this?

Kaloyan Iliev

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-01-17 19:23:46 Re: Performance problem from migrating between versions!
Previous Message PFC 2005-01-17 18:17:57 Re: Index on a function and SELECT DISTINCT