Re: old synchronized scan patch - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: old synchronized scan patch
Date
Msg-id 1165303214.3117.2.camel@localhost.localdomain
Whole thread Raw
In response to Re: old synchronized scan patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: old synchronized scan patch
List pgsql-hackers
Ühel kenal päeval, E, 2006-12-04 kell 21:46, kirjutas Tom Lane:
> Jeff Davis <pgsql@j-davis.com> writes:
> > Since I am not storing any pointers, and since the information is only
> > really a hint, I don't need to do any locking on that page.
> 
> If you think that, you need not bother to submit the patch.  (Hint:
> as soon as you consider more than one table at a time, it doesn't work,
> even ignoring the question of inconsistent reads.)

Why does it not work ?

Are you suggesting, that another backend can somegow see only some bits
of page number being written ?

What problems do you see in multiple table case ?

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: "Compacting" a relation
Next
From: Hannu Krosing
Date:
Subject: Re: "Compacting" a relation