Rick Weber wrote:
> While working on tuning my database, I was experimenting with changing
> the wal_sync_method to try to find the optimal value. The really odd
> thing is when I switch to open_sync (O_SYNC), Postgres immediately fails
> and gives me an error message of:
>
> 2008-07-22 11:22:37 UTC 19411 akamai [local] PANIC: could not write to
> log file 101, segment 40 at offset 12558336, length 2097152: No space left on device
Sounds like a kernel bug to me, particularly because the segment is most
likely already 16 MB in length; we're only rewriting the contents, not
enlarging it. Perhaps the kernel wanted to report a problem and chose
the wrong errno.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.