| From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
|---|---|
| To: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Locking in PostgreSQL? |
| Date: | 2006-12-06 07:11:44 |
| Message-ID: | 45766D30.3010008@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Hi,
Joost Kraaijeveld wrote:
> Does PostgreSQL lock the entire row in a table if I update only 1
> column?
Yes. In PostgreSQL, an update is much like a delete + insert. A
concurrent transaction will still see the old row. Thus the lock only
prevents other writing transactions, not readers.
Regards
Markus
P.S.: please do not cross post such questions.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | swati desai | 2006-12-06 07:17:15 | cant connect php to postgresql |
| Previous Message | Teodor Sigaev | 2006-12-06 07:11:21 | Re: Speed of postgres compared to ms sql, is this |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean Arnaud | 2006-12-06 08:44:16 | Re: Restart time |
| Previous Message | Joost Kraaijeveld | 2006-12-06 07:04:12 | Locking in PostgreSQL? |