From: | "alma korte" <postgres(at)zmail(dot)sk> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, |
Subject: | Trouble with recovering disc space |
Date: | 2008-05-15 12:54:04 |
Message-ID: | auto-000645155814@be1.mail.zoznam.sk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear list,
I have the following issue with recovering disc space...
Interscan Web Security Suite(Trend Micro gateway antivirus appl.) uses
Postgres database to store access logs(to the internet) in table tb_url_usage.
This table occupies approximately 12GB based on oid:
-rw------- 1 iscan iscan 1073741824 May 15 14:37 48495427
-rw------- 1 iscan iscan 1073741824 May 15 02:00 48495427.1
-rw------- 1 iscan iscan 1073741824 May 15 11:25 48495427.10
-rw------- 1 iscan iscan 1073741824 May 14 02:01 48495427.2
-rw------- 1 iscan iscan 1073741824 May 14 02:01 48495427.3
-rw------- 1 iscan iscan 1073741824 May 14 13:34 48495427.4
-rw------- 1 iscan iscan 1073741824 May 14 13:34 48495427.5
-rw------- 1 iscan iscan 1073741824 May 15 14:37 48495427.6
-rw------- 1 iscan iscan 1073741824 May 15 13:19 48495427.7
-rw------- 1 iscan iscan 1073741824 May 15 11:58 48495427.8
-rw------- 1 iscan iscan 1073741824 May 15 11:30 48495427.9
-rw------- 1 iscan iscan 399007744 May 15 09:07 48495427.11
Now, if I run a DELETE(some rows) on this table after that VACUUM FULL it
does not return any space to the operating system. These files remains. If I
am right, VACUUM FULL should decrease the physical size of the table, am I?
May I delete som of these files? Or how can I free up space on filesystem ?
I am running Postgresql version 8.0 on Fedora Core 4. If you need some
additional information I send you...
Please any advise could help!
Kind regards,
chris
--- reklama -----------------------------------------------------
Vieš, čo Ťa dnes čaká? Pozri si horoskop!
http://horoskop.zoznam.sk
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2008-05-15 16:30:31 | Re: problem in installing pgsql-8.3.1 |
Previous Message | shohorab hossain | 2008-05-15 11:21:30 | problem in installing pgsql-8.3.1 |