Re: Memory usage after upgrade to 9.2.4

From: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memory usage after upgrade to 9.2.4
Date: 2013-07-03 20:37:18
Message-ID: CACffM9Fv=TEe4LZ9+afiWDfdiLUwOBMNqAMBexsxUA6KErcv-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I found where the problem is:

http://www.postgresql.org/docs/9.1/static/release-9-1-6.html

It could be nice if something is added to the 9.2 release notes to warn the
admins.

2013/4/24 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>

> On 04/24/2013 11:20 AM, Daniel Cristian Cruz wrote:
>
>> I've done an explain analyze under the test environment, and there is no
>> aggressive memory usage.
>>
>> So I dropped the database in the new cluster and restored a fresh dump
>> from production (in theory, that's the difference between the two
>> environments).
>>
>> Some minutes after I got an answer: after a dump / restore, there is no
>> problem. The same cluster just a dump/restore.
>>
>> Since I had no idea on what is the problem, and the structure from the
>> dump of the bad database is equal to the dump from the production (it
>> differs only in check constraints where "((turma.situacao)::text = ANY
>> ((ARRAY['Aguardando Atualização'::character varying, 'Em
>> Andamento'::character varying])::text[])))" became
>> "((turma.situacao)::text = ANY (ARRAY[('Aguardando
>> Atualização'::character varying)::text, ('Em Andamento'::character
>> varying)::text])))"), how can I report a issue in pg_upgrade?
>>
>
> The bug reporting page is here:
>
> http://www.postgresql.org/**support/submitbug/<http://www.postgresql.org/support/submitbug/>
>
>
>
>> Thanks, Adrian, Tomas and Tom. It's a specific issue, it's on backup
>> until May, 1st. Until there, if someone would like to know something
>> about it, just ask me, I would like to help removing an issue.
>>
>>
>>
>
>> --
>> Daniel Cristian Cruz
>> クルズ クリスチアン ダニエル
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2013-07-03 21:56:52 Re: Analyzing last run query in psql
Previous Message Daniel Serodio (lists) 2013-07-03 20:30:19 Re: Cannot connect to remote postgres database