Re: 6.x loosing record of free space after filesystem fills?

2007-01-10 Thread Oliver Fromme
Jeremy Chadwick wrote: > Oliver Fromme wrote: > > Guy Helmer wrote: > > > I think we've finally found the cause of the problem - it wasn't just > > > occurring after heavy use, but was visible right after filesystem > > > creation! We regularly built new filesystems with "newfs -U -O 1 -b

Re: 6.x loosing record of free space after filesystem fills?

2007-01-10 Thread Oliver Fromme
Guy Helmer wrote: > Oliver Fromme wrote: > > Why are you using those blocksize and fragsize settings? > > (If you store large files, then you should at least also > > decrease the inode density, using the -i option.) > > > These settings were chosen to optimize I/O throughput for Postgresq

Re: 6.x loosing record of free space after filesystem fills?

2007-01-09 Thread Jeremy Chadwick
On Tue, Jan 09, 2007 at 06:37:16PM +0100, Oliver Fromme wrote: > Guy Helmer wrote: > > I think we've finally found the cause of the problem - it wasn't just > > occurring after heavy use, but was visible right after filesystem > > creation! We regularly built new filesystems with "newfs -U -O

Re: 6.x loosing record of free space after filesystem fills?

2007-01-09 Thread Guy Helmer
Oliver Fromme wrote: Guy Helmer wrote: > I think we've finally found the cause of the problem - it wasn't just > occurring after heavy use, but was visible right after filesystem > creation! We regularly built new filesystems with "newfs -U -O 1 -b > 65536 -f 8192" Why are you using tho

Re: 6.x loosing record of free space after filesystem fills?

2007-01-09 Thread Oliver Fromme
Guy Helmer wrote: > I think we've finally found the cause of the problem - it wasn't just > occurring after heavy use, but was visible right after filesystem > creation! We regularly built new filesystems with "newfs -U -O 1 -b > 65536 -f 8192" Why are you using those blocksize and fragsiz

Re: 6.x loosing record of free space after filesystem fills?

2007-01-08 Thread Guy Helmer
Kris Kennaway wrote: On Tue, Nov 28, 2006 at 10:45:59AM -0600, Guy Helmer wrote: We're encountering some problems on FreeBSD 6.1 SMP [...]. df shows wildly incorrect values for available space, sometimes even showing more space available than there is allocated to the partition[...] F

Re: 6.x loosing record of free space after filesystem fills?

2006-11-28 Thread Kris Kennaway
On Tue, Nov 28, 2006 at 10:45:59AM -0600, Guy Helmer wrote: > We're encountering some problems on FreeBSD 6.1 SMP with a number of > end-user systems where a Postgresql database is growing to the point > where the filesystem is nearly full or completely runs out of free > space. After this poin

Re: 6.x loosing record of free space after filesystem fills?

2006-11-28 Thread Guy Helmer
Kris Kennaway wrote: On Tue, Nov 28, 2006 at 10:45:59AM -0600, Guy Helmer wrote: We're encountering some problems on FreeBSD 6.1 SMP with a number of end-user systems where a Postgresql database is growing to the point where the filesystem is nearly full or completely runs out of free space

6.x loosing record of free space after filesystem fills?

2006-11-28 Thread Guy Helmer
We're encountering some problems on FreeBSD 6.1 SMP with a number of end-user systems where a Postgresql database is growing to the point where the filesystem is nearly full or completely runs out of free space. After this point, df shows wildly incorrect values for available space, sometimes