temporary file location?
От
Vincent Stoessel
Тема
temporary file location?
Дата
Msg-id
3C90F7F3.6020606@xaymaca.com
Список
Дерево обсуждения
temporary file location? Vincent Stoessel <vincent@xaymaca.com>
Re: temporary file location? Tom Lane <tgl@sss.pgh.pa.us>
Re: temporary file location? <raanders@acm.org>
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? my df -h looks like this: Filesystem Size Used Avail Use% Mounted on /dev/sda6 372M 215M 138M 61% / /dev/sda1 45M 16M 27M 36% /boot /dev/sda3 8.5G 811M 7.2G 10% /home none 250M 0 250M 0% /dev/shm /dev/sda2 23G 3.6G 18G 16% /usr /dev/sda7 251M 142M 96M 60% /var Yes, these are the default redhat partitions. Where is postgresql writing temporary tables to? Is that a configurable parameter? Thanks.
В списке pgsql-general по дате отправления