Re: ERROR: canceling statement due to statement timeout - Mailing list pgsql-general

From Tim
Subject Re: ERROR: canceling statement due to statement timeout
Date
Msg-id AANLkTiltkxPBo3yPuHQYXW4YAKI9u96ZDCG4niv8wlo8@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: canceling statement due to statement timeout  (Vick Khera <vivek@khera.org>)
List pgsql-general
On 6 July 2010 16:36, Vick Khera <vivek@khera.org> wrote:
> On Fri, Jul 2, 2010 at 12:22 PM, Tim <tavspam@gmail.com> wrote:
>> 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.
>>
>
> Are you using any two-phase commit (ie, prepared transactions?)
>
> We find that if you try to insert data that will conflict with data
> pending in a 2PC, you get a statement timeout immediately.

I haven't setup anything like that . But geodjango might be doing
things like that in the background.

I'll get some queries together and post them here.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: getting the last N tuples of a query
Next
From: Josip Rodin
Date:
Subject: Re: simple functions, huge overhead, no cache