Re: Must be owner to truncate?

On Sat, Jul 09, 2005 at 11:43:52PM +0300, Hannu Krosing wrote:

> Could the new file not be made to cover the next available 1GB of file
> space, that is a new physical file ?
> 
> This could made using of same kind of machinery my proposal for
> concurrent index does (i.e. locks that forbid putting new tuples in
> certain tuple ranges)

I think your proposals are too "handwavy", but there is a similar
mechanism outlined for on-line index reorganizarion, whereby new tuples
can be inserted concurrently with the reorganization, being stored on a
"spill area".  See

@inproceedings{DBLP:conf/sigmod/ZouS96,   author    = {C. Zou and B. Salzberg},   editor    = {H. V. Jagadish and
InderpalSingh Mumick},   title     = {On-line Reorganization of Sparsely-populated B+trees},   booktitle = {Proceedings
ofthe 1996 ACM SIGMOD International Conference on       Management of Data, Montreal, Quebec, Canada, June 4-6, 1996},
publisher = {ACM Press},   year      = {1996},   pages     = {115-124},   bibsource = {DBLP,
\url{http://dblp.uni-trier.de}}
}

-- 
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Para tener más hay que desear menos"