Postgres Pro
Downloads
Home   >   mailing lists

RE: Good name for new lock type for VACUUM? - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Good name for new lock type for VACUUM?
Date
Msg-id EKEJJICOHDIEMGPNIFIJIEBPEMAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: Good name for new lock type for VACUUM?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Good name for new lock type for VACUUM?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > Isn't it a better idea to have a separate 'SELF EXCLUSIVE' lock
> > which conflicts with only itself ?
> 
> *Only* itself?  What would that be useful for?

Isn't VacuumLock = RowExclusiveLock  + SelfExclusiveLock 
for the table ?

regards,
Hiroshi Inoue

pgsql-hackers by date:

Previous
From: "Joe Conway"
Date:
Subject: Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards
Next
From: Tom Lane
Date:
Subject: Re: Good name for new lock type for VACUUM?