Skip site navigation (1) Skip section navigation (2)

Re: Strange behavior after upgrade from 9.0 to 9.2

From: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
Date: 2012-10-08 11:40:31
Message-ID: 5072BBAF.5050200@wp.pl (view raw or flat)
Thread:
Lists: pgsql-performance
On 08.10.2012 12:15, Craig Ringer wrote:
> On 10/08/2012 04:18 PM, Andrzej Zawadzki wrote:
>> Hi!
>>
>> After upgrade (dump/restore/analyze) query (below) after some time is
>> killed by kernel.
>
> What's `shared_buffers`? `work_mem`?
shared_buffers = 64MB
work_mem = 48MB
effective_cache_size = 512MB

Nothing changed. Config is pretty much similar.

I noticed the correctness: when table

verification_waiting_credit

does not contain any record of user_id = 'value' then query execute very
fast.

>
> https://wiki.postgresql.org/wiki/Server_Configuration
>
> https://wiki.postgresql.org/wiki/Slow_Query_Questions
I understand but server is the same - KVM image.
Postgresql engine is different.

Table kredyty is big - contains ~3M records.
verification_waiting_credit is small - ~40 records.

Do you need schemas? I don't know if I can post here... :-(

-- 
Andrzej Zawadzki


In response to

pgsql-performance by date

Next:From: Valentine GogichashviliDate: 2012-10-08 12:20:09
Subject: Re: UPDATE execution time is increasing
Previous:From: Craig RingerDate: 2012-10-08 10:15:15
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group