On 08.10.2012 12:15, Craig Ringer wrote:
> On 10/08/2012 04:18 PM, Andrzej Zawadzki wrote:
>> 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
does not contain any record of user_id = 'value' then query execute very
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... :-(
In response to
pgsql-performance by date
|Next:||From: Valentine Gogichashvili||Date: 2012-10-08 12:20:09|
|Subject: Re: UPDATE execution time is increasing|
|Previous:||From: Craig Ringer||Date: 2012-10-08 10:15:15|
|Subject: Re: Strange behavior after upgrade from 9.0 to 9.2|