pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alma korte <postgres@zmail.sk>
To: pgsql-admin@postgresql.org
Subject: Trouble with recovering disc space
Date: Thu, 15 May 2008 14:54:04 +0200
Message-ID: <auto-000645155814@be1.mail.zoznam.sk> (raw)

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



view thread (2+ messages)  latest in thread

Message-ID: <auto-000645155814@be1.mail.zoznam.sk>
Permalink:  ../auto-000645155814@be1.mail.zoznam.sk/
Also on:    postgresql.org/message-id/auto-000645155814@be1.mail.zoznam.sk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: postgres@zmail.sk
  Subject: Re: Trouble with recovering disc space
  In-Reply-To: <auto-000645155814@be1.mail.zoznam.sk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox