On Fri, May 20, 2011 at 12:35 PM, Tomasz Chmielewski <mangoo@xxxxxxxx> wrote: > > Nobody has a clue what makes btrfs run out of space when used with PostgreSQL, even when there is plenty of free space left? > > > # df -h > Filesystem Size Used Avail Use% Mounted on > /dev/sdb4 336G 257G 78G 77% /mnt/btrfs > > > coredb=# DELETE FROM core_trevent where "date" < E'2011-05-07 00:00'; > ERROR: could not write block 1014999 of relation base/16384/16521: No space left on device > CONTEXT: writing block 1014999 of relation base/16384/16521 > Hi Tomasz, What does btrfs fi df /mountpoint show? Please see this link: https://btrfs.wiki.kernel.org/index.php/FAQ#Help.21_Btrfs_claims_I.27m_out_of_space.2C_but_it_looks_like_I_should_have_lots_left.21 As well as this one: https://btrfs.wiki.kernel.org/index.php/FAQ#Why_are_there_so_many_ways_to_check_the_amount_of_free_space.3F -- MG -- To unsubscribe from this list: send the line "unsubscribe linux-btrfs" in the body of a message to majordomo@xxxxxxxxxxxxxxx More majordomo info at http://vger.kernel.org/majordomo-info.html
