From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Vincent Stoessel <vincent(at)xaymaca(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: temporary file location? |
Date: | 2002-03-14 20:35:03 |
Message-ID: | 17374.1016138103@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Vincent Stoessel <vincent(at)xaymaca(dot)com> writes:
> At the end of a long query that I am running I got the following error:
> ERROR: ltsWriteBlock: failed to write block 2427094 of temporary file
> Perhaps out of disk space?
Hm ... bc says 2427094 * 8192 = 19882754048, or about 18.5Gb.
> Yes, these are the default redhat partitions. Where is postgresql
> writing temporary tables to? Is that a configurable parameter?
They're under $PGDATA, and you're already filling your biggest
partition, so moving won't help anyway. I'd suggest looking for a more
efficient way to do the query, instead.
Considering that your total database must be somewhere under 3.6G,
I wonder whether your query is even correct --- why should it be needing
18+G (possibly far more, we cannot tell) of temp data? I wonder if
you've got an unconstrained join or something like that.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Snyder | 2002-03-14 20:45:28 | Re: Unexplainable slow down... |
Previous Message | otisg | 2002-03-14 20:09:33 | Re: pgmonitor |