Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 39DFD2E002F for ; Thu, 15 May 2008 10:00:44 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90701-08 for ; Thu, 15 May 2008 10:00:15 -0300 (ADT) X-Greylist: delayed 00:06:04.073817 by SQLgrey-1.7.6 Received: from mail.zoznam.sk (mail.zoznam.sk [213.81.185.32]) by developer.postgresql.org (Postfix) with ESMTP id 969792E0031 for ; Thu, 15 May 2008 10:00:12 -0300 (ADT) X-Scan: Zoznam LOCAL Received: from dummy.name; Thu, 15 May 2008 14:54:04 +0200 MIME-Version: 1.0 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Date: Thu, 15 May 2008 14:54:04 +0200 From: "alma korte" To: pgsql-admin@postgresql.org, Subject: Trouble with recovering disc space X-Mailer: Zoznam Mailer v.1.2 X-Www-Freemail-Ip: 83.168.162.121 Message-ID: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200805/136 X-Sequence-Number: 29220 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_usa= ge. 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=C5=A1, =C4=8Do =C5=A4a dnes =C4=8Dak=C3=A1? Pozri si horoskop! http://horoskop.zoznam.sk