"Chris Dorr" <chris@townnews.com> writes:
> I've got a postgres DB that keeps crashing on me. When I go into my
> base/DBDIR/ and do an ls -la I see a ton of files called pg_sorttemp .
> Some are quite large in size and others have nothing inside of them.
> Would this have anything to do with why our DB is crashing?? Can I
> get rid of them?
They're just temporary files. You can get rid of them if the backends
that created 'em are no longer running. The more interesting question
is why the crashes. What version are you running, and what sort of
query is provoking the crash?
regards, tom lane