[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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings