ERROR: canceling statement due to statement timeout

Поиск
Список
Период
Сортировка
От Tim
Тема ERROR: canceling statement due to statement timeout
Дата
Msg-id AANLkTimRhII2l-xT9dxvQmOlvGZl5_-QzzV8kYtQBtYx@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR: canceling statement due to statement timeout  (Craig Ringer <craig@postnewspapers.com.au>)
Re: ERROR: canceling statement due to statement timeout  (Vick Khera <vivek@khera.org>)
Список pgsql-general
Hi,

I've had a website up for a couple of months and it's starting to get
these db timeouts as traffic has increased to say 1k pageviews a day.

It uses django with the gis stuff to find distances from user to
object and it's hosted on webfaction. I've asked webfaction about it
and they say no one else is having postgres problems on my server.

My question is which (anonymizable) infomation can I post here so that
you helpful people can assist with with a diagnosis and hopefully a
fix?

Thanks,
Tim

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

Предыдущее
От: Saitenheini@web.de
Дата:
Сообщение: Re: C-functions using SPI Missing Magic Block Error
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum and pg_largeobject