Home > mailing lists

Select and update with limit and locking - Mailing list pgsql-novice

From	matt w
Subject	Select and update with limit and locking
Date	January 24, 2011 05:22:31
Msg-id	AANLkTinmG0PKSb8ipSJhWN+Pc0jZ5OziVL-Oat1UgVKQ@mail.gmail.com Whole thread Raw
Responses	Re: Select and update with limit and locking (Sean Davis <sdavis2@mail.nih.gov>)
List	pgsql-novice

I'm trying to implement a priority queue. Performance is not much of an issue but there will be about 10m entries.

I need to lock the table, select ~1000 entries (out of ~1m matching the query) and update fields on only the entries selected.

Thanks so much for any help you can give me.

From: Mladen Gogala
Date: 23 January 2011, 01:48:34
Subject: Re: Passing a variable from the user interface to PostgreSQL

From: Sean Davis
Date: 24 January 2011, 08:53:09
Subject: Re: Select and update with limit and locking