[snip] > Note: on Linux I've had success with simply truncating the file using: > > : > [filename] > > This does free up the space used straightaway. Depending on the mode > the file was opened with it may also reset the position the postmaster > writes at. Interesting hint, I'll try it next time I'll need such effect, although I won't do it with any production data base ;-) Thanks Martijn ! Cheers, Csaba.