Troubles with Postgresql performance

Поиск
Список
Период
Сортировка
От Denis Mironchuk
Тема Troubles with Postgresql performance
Дата
Msg-id CA+AqhiQdSqqFJVo7kXFOL_oe=h68dc1XA0M6fU6nRXmAePrL3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Troubles with Postgresql performance
Список pgsql-general
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 created less then in a second, and queries worked fast again. What may be the reason?

I understand that this information is not enough to give some reasonable answer but still will be grateful for any advise.

В списке pgsql-general по дате отправления:

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_restore: custom archiver unexpected end of file , ERROR: missing data for column