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.