Re: Upgrading from 9.2 to 9.3 causes performance degradation
| От | Álvaro Nunes Lemos Melo |
|---|---|
| Тема | Re: Upgrading from 9.2 to 9.3 causes performance degradation |
| Дата | |
| Msg-id | 819250335.5570.1395714743020.JavaMail.zimbra@atua.com.br обсуждение исходный текст |
| Ответ на | Re: Upgrading from 9.2 to 9.3 causes performance degradation (Jeff Janes <jeff.janes@gmail.com>) |
| Ответы |
Upgrading from 9.2 to 9.3 causes performance degradation
Re: Upgrading from 9.2 to 9.3 causes performance degradation Re: Upgrading from 9.2 to 9.3 causes performance degradation |
| Список | pgsql-general |
Jeff: I ran a VACUUM FULL ANALYZE and retested. No significative change was notices, the explain is availiable in
9.3 - After VACUUM FULL ANALYZE - http://explain.depesz.com/s/rVoW
9.3 - Original - http://explain.depesz.com/s/Vwt
Adrian: I'll try to send the query attached. My doubts are: why 9.3 is slower then 9.2 with the same database/configuration/harware/query? Even worst, why 9.3 got slower results on a better HW, where 9.2 improved on the same scenario.
I've just ran the explains on my new server, links below:
9.2 - http://explain.depesz.com/s/AeD
9.3 - http://explain.depesz.com/s/1sp
For comparison sake, old server:
9.2 - http://explain.depesz.com/s/bXIo
9.3 - http://explain.depesz.com/s/Vwt
9.2 - http://explain.depesz.com/s/bXIo
9.3 - http://explain.depesz.com/s/Vwt
I really appreciate your help.
Thanks again,
--
Álvaro Nunes Melo Atua Sistemas de Informação
alvaro@atua.com.br http://www.atua.com.br
(54) 9976-0106 (54) 3045-4144
Álvaro Nunes Melo Atua Sistemas de Informação
alvaro@atua.com.br http://www.atua.com.br
(54) 9976-0106 (54) 3045-4144
De: "Jeff Janes" <jeff.janes@gmail.com>
Para: "Álvaro Nunes Lemos Melo" <al_nunes@atua.com.br>
Cc: pgsql-general@postgresql.org
Enviadas: Segunda-feira, 24 de março de 2014 15:29:38
Assunto: Re: [GENERAL] Upgrading from 9.2 to 9.3 causes performance degradation
Para: "Álvaro Nunes Lemos Melo" <al_nunes@atua.com.br>
Cc: pgsql-general@postgresql.org
Enviadas: Segunda-feira, 24 de março de 2014 15:29:38
Assunto: Re: [GENERAL] Upgrading from 9.2 to 9.3 causes performance degradation
On Mon, Mar 24, 2014 at 7:45 AM, Álvaro Nunes Lemos Melo <al_nunes@atua.com.br> wrote:
==> Venkata> After the migration to hardware and to the new version 9.3, any changes have been done in the postgresql.conf compared to the old settings ?No, as I wrote initially, I'd double checked and the four conf files have the same parameters.ANALYZE yes. VACUUM or VACUUM FULL no, because I ran the test on recently restores and unchanged databases.
> Any maintenance activities (VACUUM or VACUUM FULL and ANALYZE) have been performed after the migration ?
How did you do the restore? Please VACUUM and retest. At best it will fix the problem, and if it doesn't it will at least rule out a bunch of possibilities for the source of the problem.
Cheers,
Jeff
Вложения
В списке pgsql-general по дате отправления: