[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.