Hi all just recently a large postgres database that has been happily chugging away with no problems has gone a bit wild. It is in the ~/data/base/16450 directory were there are suddenly since Oct 10th lots of 1GB files being created and not going away (see output from ls below). This is chewing up the disk space at a phenomenal rate, does anyone have any clues as to what would cause this to start happening and how to fix it?
Thanks in advance
John.
Thanks in advance
John.
Code:
-rw------- 1 postgres postgres 1.0G Oct 10 00:48 16464.2 -rw------- 1 postgres postgres 2.6M Oct 10 08:01 16468 -rw------- 1 postgres postgres 90M Oct 10 08:01 16466 -rw------- 1 postgres postgres 40M Oct 10 08:01 16498 -rw------- 1 postgres postgres 48M Oct 10 08:01 1410576 -rw------- 1 postgres postgres 172M Oct 10 08:01 16496 -rw------- 1 postgres postgres 224M Oct 10 08:01 16487 -rw------- 1 postgres postgres 6.8M Oct 10 08:01 16478 -rw------- 1 postgres postgres 208M Oct 10 08:01 16476 -rw------- 1 postgres root 1.0G Oct 10 08:01 2613.62 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.56 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.57 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.22 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.71 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.65 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.40 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.45 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.58 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.34 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.11 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.10 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.49 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.25 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.8 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.7 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.6 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.31 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.48 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.2 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.52 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.5 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.3 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.1 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.51 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.20 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.74 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.68 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.9 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.29 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.67 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.50 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.24 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.69 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.4 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.73 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.64 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.60 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.14 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.70 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.61 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.43 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.42 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.16 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.37 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.35 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.30 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.59 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.21 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.12 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.54 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.46 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.36 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.23 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.17 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.19 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.85 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.53 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.18 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.15 -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.44 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.75 -rw------- 1 postgres postgres 103M Oct 10 08:02 33822 -rw------- 1 postgres postgres 133M Oct 10 08:02 33821 -rw------- 1 postgres root 23M Oct 10 08:02 2613.89 -rw------- 1 postgres root 1.0G Oct 10 08:02 2613.79 -rw------- 1 postgres postgres 850M Oct 10 08:02 16497 -rw------- 1 postgres postgres 452M Oct 10 08:02 16492 -rw------- 1 postgres postgres 476M Oct 10 08:02 16491 -rw------- 1 postgres postgres 584M Oct 10 08:02 16479 -rw------- 1 postgres postgres 8.0K Oct 10 08:02 16462 -rw------- 1 postgres root 1.0G Oct 10 08:35 2613.78 -rw------- 1 postgres root 1.0G Oct 10 08:39 2613.86 -rw------- 1 postgres root 1.0G Oct 10 09:04 2613.84 -rw------- 1 postgres root 1.0G Oct 10 09:04 2613.87 -rw------- 1 postgres root 1.0G Oct 10 09:04 2613.72 -rw------- 1 postgres root 1.0G Oct 10 09:06 2613.83 -rw------- 1 postgres postgres 1.0G Oct 10 09:15 16451 -rw------- 1 postgres root 1.0G Oct 10 09:15 2613.80 -rw------- 1 postgres root 1.0G Oct 10 09:18 2613.77 -rw------- 1 postgres postgres 627M Oct 10 09:32 16474 -rw------- 1 postgres root 128M Oct 10 09:40 16464.3 -rw------- 1 postgres postgres 1.0G Oct 10 09:41 2683 -rw------- 1 postgres root 1.0G Oct 10 09:41 2613.76 -rw------- 1 postgres root 1.0G Oct 10 09:42 2613.81 -rw------- 1 postgres postgres 364M Oct 10 09:43 16451.1 -rw------- 1 postgres root 1.0G Oct 10 09:43 2613.88 -rw------- 1 postgres postgres 209M Oct 10 09:45 33820 -rw------- 1 postgres root 126M Oct 10 09:45 2683.1 -rw------- 1 postgres root 1.0G Oct 10 09:45 2613.82