| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Ilja Golshtein <ilejn(at)yandex(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: table locks |
| Date: | 2006-12-25 14:28:01 |
| Message-ID: | 20061225142801.GB10047@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2006-12-25 15:31:48 | Re: Merry Christmas! |
| Previous Message | Ilja Golshtein | 2006-12-25 11:58:26 | table locks |