pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedautomatic table locking on too many locked records?
2+ messages / 2 participants
[nested] [flat]
* automatic table locking on too many locked records?
@ 2005-01-20 16:39 KÖPFERL Robert <robert.koepferl@sonorys.at>
0 siblings, 1 reply; 2+ messages in thread
From: KÖPFERL Robert @ 2005-01-20 16:39 UTC (permalink / raw)
To: pgsql-sql
Hi all and Michael.
An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table
gets locked if a certain percentage or amount of records are locked due to
an update. And then shortly nothing goes.
Does there exist a similar behaviour on pgSQL? Get tables locked if too many
records are beein updated? Or something elses?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: automatic table locking on too many locked records?
@ 2005-01-20 17:01 Richard Huxton <dev@archonet.com>
parent: KÖPFERL Robert <robert.koepferl@sonorys.at>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2005-01-20 17:01 UTC (permalink / raw)
To: KÖPFERL Robert <robert.koepferl@sonorys.at>; +Cc: pgsql-sql
KÖPFERL Robert wrote:
> Hi all and Michael.
>
> An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table
> gets locked if a certain percentage or amount of records are locked due to
> an update. And then shortly nothing goes.
> Does there exist a similar behaviour on pgSQL? Get tables locked if too many
> records are beein updated? Or something elses?
PostgreSQL's MVCC system means updates generally don't lock at all. For
more info, Google for MVCC and check the manual for Transaction
Isolation Levels.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-01-20 17:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-20 16:39 automatic table locking on too many locked records? KÖPFERL Robert <robert.koepferl@sonorys.at>
2005-01-20 17:01 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox