I was about to suggest the same , but also , it can be a problem of write
permision , or quotas.
Also that issues a perfomance boost I have been triying , using reiserfs for
the database files but a simple ext2fs for tmp partition.
(yesterday , after a gone wild report generation , had to remove 800Mb of
two /tmp/gds_sort* files)
the perfomace boost seems to be related to the overhead that the extra cheks
of ReiserFs puts on the system.

exactly , Xavi , What size of tables are we talking of ?

Javi
EntreBytes S.L.
Ontenient , Spain
ERP Development.

----- Original Message -----
[Snip]
> Xavier,
> Is it possible you are out of space in /tmp? You can actually configure
> specific areas your filesystem for the temp sort files...I don't use /tmp
> for sort files at all because my setup has only a 2 Mb /tmp partition.
>
> regards,
> Helen