On 6 July 2010 16:36, Vick Khera <vivek@xxxxxxxxx> wrote: > On Fri, Jul 2, 2010 at 12:22 PM, Tim <tavspam@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
