Skip site navigation (1) Skip section navigation (2)

Re: Delete low priority equivalent in postgresql?

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Vaduvoiu Tiberiu <vaduvoiutibi(at)yahoo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Delete low priority equivalent in postgresql?
Date: 2010-11-09 14:49:55
Message-ID: 4CD95F93.7040400@vmsinfo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Vaduvoiu Tiberiu wrote:
> I'm switching my application's database from MySql to Postgresql. I've 
> noticed a couple of "delete low priority from..." queries that were 
> added by a different employee that I need to "translate" in 
> Postgresql. From what I understand, in MySql "low priority" option can 
> be used to wait that no more client reads the table before updating 
> it. Is there an equivalent for this in Postgresql or should I simply 
> remove this option from the query to make it work in Postgresql?
>
> Thanx in advance
>
>
In PostgreSQL, readers do not block writers and vice versa. PostgreSQL 
has so called "non-overwriting multi version control" which allows both 
readers and writers to operate on the table concurrently, at least when 
operating under the default transaction isolation level. That means that 
"low priority" option doesn't make much sense for PostgreSQL. Just 
remove it.

-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com 


In response to

pgsql-novice by date

Next:From: Dragan KeseljDate: 2010-11-09 17:18:23
Subject: Question - help needed
Previous:From: Thom BrownDate: 2010-11-09 14:17:21
Subject: Re: MySql Concat function equivalent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group