Re: [GENERAL] Troubles with Postgresql performance

2014-06-18 Thread Kevin Grittner
Denis Mironchuk wrote: > Hello. I had a strange issue with postgresql 9.3 server. Load on > server rapidly increased, queries which took about 4ms were > executed for 100ms and creation a foreign key on empty table > blocked all queries to server. After server restart everithing > became fine aga

[GENERAL] Troubles with Postgresql performance

2014-06-18 Thread Denis Mironchuk
Hello. I had a strange issue with postgresql 9.3 server. Load on server rapidly increased, queries which took about 4ms were executed for 100ms and creation a foreign key on empty table blocked all queries to server. After server restart everithing became fine again, the same foreign key was create