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
クルズ クリスチアン ダニエル
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 |