Try
Home   >   mailing lists

Re: Regarding query optimisation (select for update) - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Regarding query optimisation (select for update)
Date
Msg-id CAKAnmmK5mJh+3_p5i41UVV41M_dr9wLz-m7c=V2O343X-MDWfw@mail.gmail.com
Whole thread Raw
In response to Re: Regarding query optimisation (select for update)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
You might want to examine the SKIP LOCKED feature as well, if you are using this query to have multiple workers grab chunks of the table to work on concurrently.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regarding query optimisation (select for update)
Next
From: Greg Hennessy
Date:
Subject: Re: optimizing number of workers