On Monday, March 24, 2014, Álvaro Nunes Lemos Melo
al_nu...@atua.com.brjavascript:_e(%7B%7D,'cvml','al_nu...@atua.com.br');
wrote:
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 -
On 3/24/2014 7:45 AM, Álvaro Nunes Lemos Melo wrote:
- New: Xeon E5-2430 2.20GHz
- Old: Xeon X3470 2.93GHz
Memory: 8 GBs
note your OLD server was faster per gigahertz. Intel PR not
withstanding, GHz remains more important for single threaded performance
than about anything else. the
On 03/24/2014 07:32 PM, Álvaro Nunes Lemos Melo wrote:
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 browsed through messages related to this issue? I have a few questions to
the OP. How did you upgrade? Did you reindex the database? Try reindexdb
and see what happens. If you used pg_upgrade, you need to reindex. I did
pg_upgrade on my production db and it wasn't any faster on 9.3 than on 9.0,
(54) 9976-0106 (54) 3045-4144
De: Jeff Janes jeff.ja...@gmail.com
Para: Álvaro Nunes Lemos Melo al_nu...@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 Sun, 23 Mar 2014 20:58:03 -0300 (BRT)
Álvaro Nunes Lemos Melo al_nu...@atua.com.br wrote:
Hi,
Recently, I've been trough a datacenter migration, and in this
operation I'd also upgraded my PostgreSQL version from 9.2 to 9.3. My
new hardware is slightly better than the old one, but the
março de 2014 6:00:54
Assunto: Re: [GENERAL] Upgrading from 9.2 to 9.3 causes performance degradation
On Sun, 23 Mar 2014 20:58:03 -0300 (BRT)
Álvaro Nunes Lemos Melo al_nu...@atua.com.br wrote:
Hi,
Recently, I've been trough a datacenter migration, and in this
operation I'd also upgraded my
On 03/24/2014 07:45 AM, Álvaro Nunes Lemos Melo wrote:
Firstly, I'd like to thanks all of you guys for your help. Below, I'll try to
provide all the information you asked. I know the query I'm testing could be
improved, but I used it because it's not that fast that is hard to measure
neither
On Mon, Mar 24, 2014 at 7:45 AM, Álvaro Nunes Lemos Melo
al_nu...@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
-4144
- Mensagem original -
De: Jeff Janes jeff.ja...@gmail.com
Para: Álvaro Nunes Lemos Melo al_nu...@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
Hi,
Recently, I've been trough a datacenter migration, and in this operation I'd
also upgraded my PostgreSQL version from 9.2 to 9.3. My new hardware is
slightly better than the old one, but the PostgreSQL performance has shown
degradation in the whole system.
Trying to figure out what could
On 03/23/2014 04:58 PM, Álvaro Nunes Lemos Melo wrote:
Hi,
Recently, I've been trough a datacenter migration, and in this operation I'd
also upgraded my PostgreSQL version from 9.2 to 9.3. My new hardware is
slightly better than the old one, but the PostgreSQL performance has shown
On Mar 23, 2014, at 7:58 PM, Álvaro Nunes Lemos Melo wrote:
...
the whole system is slower.
Below is my data, and I really hope we can find what is happening, or I'll
have to downgrade to 9.2 and wait for 9.4 release.
I think this is a good starting place:
On Mon, Mar 24, 2014 at 10:58 AM, Álvaro Nunes Lemos Melo
al_nu...@atua.com.br wrote:
Hi,
Recently, I've been trough a datacenter migration, and in this operation
I'd also upgraded my PostgreSQL version from 9.2 to 9.3. My new hardware is
slightly better than the old one, but the PostgreSQL
14 matches
Mail list logo