Home > mailing lists

Lock Problem - Mailing list pgsql-sql

From	André José Guergolet
Subject	Lock Problem
Date	August 24, 2006 20:50:02
Msg-id	3FFA1818C1550246933DEA311C39B076123047@CGEXC03.compugraf.com.br Whole thread Raw
Responses	Re: Lock Problem (Andrew Sullivan <ajs@crankycanuck.ca>)
List	pgsql-sql

Hello all, I'm using the Postgres 8.0 and my product creates 7 connections at the server.

One of my connections do an update at a simple table with 360 rows and I've got many table locks. How I can take more scability?

Thanks, and sorry about my english.

From: "Travis Whitton"
Date: 24 August 2006, 19:01:55
Subject: Performance Problem with sub-select using array

From: Andrew Sullivan
Date: 24 August 2006, 20:53:14
Subject: Re: Lock Problem