ERROR: canceling statement due to statement timeout

From: Tim <tavspam(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: canceling statement due to statement timeout
Date: 2010-07-02 16:22:45
Message-ID: AANLkTimRhII2l-xT9dxvQmOlvGZl5_-QzzV8kYtQBtYx@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-07-02 16:57:22 Re: Autovacuum and pg_largeobject
Previous Message Saitenheini 2010-07-02 15:52:08 Re: C-functions using SPI Missing Magic Block Error