473,385 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Database gone a bit wild

1
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.

Expand|Select|Wrap|Line Numbers
  1. -rw------- 1 postgres postgres 1.0G Oct 10 00:48 16464.2
  2. -rw------- 1 postgres postgres 2.6M Oct 10 08:01 16468
  3. -rw------- 1 postgres postgres  90M Oct 10 08:01 16466
  4. -rw------- 1 postgres postgres  40M Oct 10 08:01 16498
  5. -rw------- 1 postgres postgres  48M Oct 10 08:01 1410576
  6. -rw------- 1 postgres postgres 172M Oct 10 08:01 16496
  7. -rw------- 1 postgres postgres 224M Oct 10 08:01 16487
  8. -rw------- 1 postgres postgres 6.8M Oct 10 08:01 16478
  9. -rw------- 1 postgres postgres 208M Oct 10 08:01 16476
  10. -rw------- 1 postgres root     1.0G Oct 10 08:01 2613.62
  11. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.56
  12. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.57
  13. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.22
  14. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.71
  15. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.65
  16. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.40
  17. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.45
  18. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.58
  19. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.34
  20. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.11
  21. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.10
  22. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613
  23. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.49
  24. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.25
  25. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.8
  26. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.7
  27. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.6
  28. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.31
  29. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.48
  30. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.2
  31. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.52
  32. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.5
  33. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.3
  34. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.1
  35. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.51
  36. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.20
  37. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.74
  38. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.68
  39. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.9
  40. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.29
  41. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.67
  42. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.50
  43. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.24
  44. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.69
  45. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.4
  46. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.73
  47. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.64
  48. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.60
  49. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.14
  50. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.70
  51. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.61
  52. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.43
  53. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.42
  54. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.16
  55. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.37
  56. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.35
  57. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.30
  58. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.59
  59. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.21
  60. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.12
  61. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.54
  62. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.46
  63. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.36
  64. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.23
  65. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.17
  66. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.19
  67. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.85
  68. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.53
  69. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.18
  70. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.15
  71. -rw------- 1 postgres postgres 1.0G Oct 10 08:02 2613.44
  72. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.75
  73. -rw------- 1 postgres postgres 103M Oct 10 08:02 33822
  74. -rw------- 1 postgres postgres 133M Oct 10 08:02 33821
  75. -rw------- 1 postgres root      23M Oct 10 08:02 2613.89
  76. -rw------- 1 postgres root     1.0G Oct 10 08:02 2613.79
  77. -rw------- 1 postgres postgres 850M Oct 10 08:02 16497
  78. -rw------- 1 postgres postgres 452M Oct 10 08:02 16492
  79. -rw------- 1 postgres postgres 476M Oct 10 08:02 16491
  80. -rw------- 1 postgres postgres 584M Oct 10 08:02 16479
  81. -rw------- 1 postgres postgres 8.0K Oct 10 08:02 16462
  82. -rw------- 1 postgres root     1.0G Oct 10 08:35 2613.78
  83. -rw------- 1 postgres root     1.0G Oct 10 08:39 2613.86
  84. -rw------- 1 postgres root     1.0G Oct 10 09:04 2613.84
  85. -rw------- 1 postgres root     1.0G Oct 10 09:04 2613.87
  86. -rw------- 1 postgres root     1.0G Oct 10 09:04 2613.72
  87. -rw------- 1 postgres root     1.0G Oct 10 09:06 2613.83
  88. -rw------- 1 postgres postgres 1.0G Oct 10 09:15 16451
  89. -rw------- 1 postgres root     1.0G Oct 10 09:15 2613.80
  90. -rw------- 1 postgres root     1.0G Oct 10 09:18 2613.77
  91. -rw------- 1 postgres postgres 627M Oct 10 09:32 16474
  92. -rw------- 1 postgres root     128M Oct 10 09:40 16464.3
  93. -rw------- 1 postgres postgres 1.0G Oct 10 09:41 2683
  94. -rw------- 1 postgres root     1.0G Oct 10 09:41 2613.76
  95. -rw------- 1 postgres root     1.0G Oct 10 09:42 2613.81
  96. -rw------- 1 postgres postgres 364M Oct 10 09:43 16451.1
  97. -rw------- 1 postgres root     1.0G Oct 10 09:43 2613.88
  98. -rw------- 1 postgres postgres 209M Oct 10 09:45 33820
  99. -rw------- 1 postgres root     126M Oct 10 09:45 2683.1
  100. -rw------- 1 postgres root     1.0G Oct 10 09:45 2613.82
Oct 10 '08 #1
0 2748

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Paweł | last post by:
Hello! I'm looking for efficient code or site where I can find code for finding one string in another string. String which I search should have "wild" characters like '?' for any one char and...
346
by: rkusenet | last post by:
http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.
1
by: Tom Wild | last post by:
Hi I am trying to create a webform that connects to an Access database. If I use the connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb" Then the application...
7
by: News | last post by:
Hello, I have to build a program with the future in mind and I need a bit of guidance from a guru or two. My program will start as a multi-user Windows Application built with VB.Net and using an...
6
by: LurfysMa | last post by:
I am working on an electronic flashcard application. I have one version up and running using Visual Basic (6.0) and Access 2000. My long-range plans are to put it up on a website and sell...
11
by: bgreen | last post by:
I am hoping for some assistance with formatting a large text file which consists of a series of individual records. Each record includes specific labels/field names (a sample of 1 record (one of...
17
by: Flic | last post by:
Is this possible? I know about a bit about ODBC and found how to import an ODBC database stored on the computer, however I am after accessing an SQL database stored on a webserver. I'd like to...
5
by: Dave | last post by:
I need to filter an Access 2000 result set in ASP 30 using the ADO recordset.filter. I build the filter in pieces. The first clause of the filter is this... WHERE word LIKE 'S%' ... to...
7
by: mmckinnon | last post by:
Hi All, I have a mainform that hold a template for house remodeling. Then I have a subform that holds the tasks needed to accomplish the house remodel. The subfrom is a list of continuous...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.