Deadlock problems

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: Deadlock problems
Date: 1999-05-26 13:48:23
Message-ID: 374BFBA7.905E803C@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm not using any explicit transactions when I use Postgres. I would
have thought this would exclude me from deadlock problems. After all, If
I never have explicit transactions, it's not obvious that you would be
holding locks.

Can I turn off locks altogether? Basicly I'm just dynamically generating
web pages with various joins out of postgres. But even if these simple
queries can cause deadlocks, well it just doesn't work, and performance
dies. It would seem crazy if I had to worry a lot about locks just to do
web page generation/queries.

If it matters, I'm using a 6.5 beta with Perl.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message johan.granlund 1999-05-26 13:57:08 Re: [GENERAL] So slow inserts... Why?
Previous Message AIS 1999-05-26 13:35:39 psql and -f