Re: exclusive locking on SELECT ?

Dave Cramer wrote:
>
> On 11-Jan-07, at 4:47 PM, James Neff wrote:
>
>> Greetings,
>>
>> I have 3 clients trying to do a select on the same table (different
>> rows). pgAdmin III Server Status shows the queries and has as mode
>> "Exclusive Lock" for all three.
> Are you doing select for update ? If so why so many rows ?
>
>

No updates, just a select. Is there a way (in Java) to only select one
row at a time from a resultset, and is this a good idea? The clients
are processing rows from this one table in 2000 record chunks. There
are about 9 million rows total to process.

>>
>> How would I go about diagnosing this situation, and how do I fix it?
>
> Have you tuned the server ?

I'm doing a search now on "tuning postgres". Do you have any suggested
links that might pertain to my particular situation?

Thanks again,
James