On Mon, Dec 25, 2006 at 02:58:26PM +0300, Ilja Golshtein wrote:
> Hello!
>
> I need table locks to provide application logic. Just very common lock types with very common behavior - Shared and
Exclusive.
>
> Which PostgreSQL's lock modes should be preferred in order to avoid conflicts with autovacuum and suchlike?
The documentation on locks clearly lists what lock types conflict with
what.
But seriously, why block autovacuum? It no visible effect on the table.
Why do you want to lock at all? Lock-free designs are always better.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.