> there should be enough space for temp-file (2GB)

...

> The database is around 2GB (at the moment).

It is quite easy to write query that will require temp space
several times larger than the whole database.

Ivan