| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Valentine Gogichashvili | 2012-10-08 12:20:09 | Re: UPDATE execution time is increasing |
| Previous Message | Craig Ringer | 2012-10-08 10:15:15 | Re: Strange behavior after upgrade from 9.0 to 9.2 |