Alex Hunsaker <badalex@xxxxxxxxx> writes: > On Mon, Jul 26, 2010 at 16:01, Irene Barg <ibarg@xxxxxxxx> wrote: > 2010-07-26 11:33:33 MST system_admin metadataERROR: Â could not write block > 503414 of temporary file: No space le > ft on device > 2010-07-26 11:33:33 MST system_admin metadataHINT: Â Perhaps out of disk > space? > Ok so it looks like this is on your / (sda3) partition that only has > 1.7G free. Its entirely possible that you have some query that needs > to write more than that in tmp files. "Block 503414" is a red flag here --- that means that this temp file alone required 503414 * 8K = nearly 4Gb. I suspect /var/lib/pgsql has been symlinked someplace else, as the root device has clearly not got anything close to that much free space. It's quite possible that the query involved multiple temp files, though, so maybe one of the other partitions is getting filled. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
