Fwd: [rt-users] crazy sql during "reply" action

Jamie Wilkinson jaq at spacepants.org
Fri Apr 11 12:36:20 EDT 2003


This one time, at band camp, Nicolae P. Costescu wrote:
>15 minutes - check if you are running out of disk space while this query is 
>running. When postgres has used up its sort ram it will writ 
>pg_sorttempXXXX files to the database directory and do sorts on disk. If 
>you have a bad query, this will go on until you run out of disk space, at 
>which time the postgres backend you were talking to will die and clean up 
>all its temp sort files (so you dont' see the evidence). You have to do a 
>disk usage while it's running and see if that's the cause.

Nah, the machine has more disk than we really know what to do with, and it's
certainly not running out of RAM.  As Jesse said, the thread on rt-devel
contained some of the answers to my questions -- it's a problem with the way
the queries are being created.

Short of hacking on it (DBIx::SearchBuilder, I think) myself, I'm going to
hope that the guys who are already working on it come up with a good
solution soon :-)

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg



More information about the rt-users mailing list