Re: reducing postgresql disk space

From: paladine <yasinmalli(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: reducing postgresql disk space
Date: 2010-05-27 10:21:13
Message-ID: 28690076.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


command output for mentioned db : ' my_db_name | 42 GB '

I don't print query results to logfile. I restore my system logs to db.
I have a lot of live ( growing ) logs on my machine and I register these
logs to db.
My essential question is that why don't I reclaim disk space though I run
this command
'delete from db ....' ?

Thom Brown wrote:
>
> On 26 May 2010 15:50, paladine <yasinmalli(at)gmail(dot)com> wrote:
>>
>> It is default value ( #checkpoint_segments = 3    # in logfile segments,
>> min
>> 1, 16MB each )
>> Many of my database configurations are default values. (plain TOAST  etc)
>> my database is a log database so, some tables of db grow everytime.
>> My ' /base ' directory contains a lot of compressed object (1GB size)
>> These are maybe normal operations but I don't understand that
>> although I delete many rows from my db and regularly vacuum , reindexing
>> operations,
>> how doesn't postgresql give back that deleted areas for reusing.
>>
>
> I'm just wondering if you're still building up the initial set of WAL
> files which will begin to plateau if the data in your database in
> roughly consistent in size over time.
>
> Try:
>
> select datname, pg_size_pretty(pg_database_size(datname)) from
> pg_database order by datname;
>
> That should give you the actual sizes of each database. Also, how
> verbose is the database logging? If you're logging every query to a
> log file that may also account for it.
>
> Regards
>
> Thom
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context: http://old.nabble.com/reducing-postgresql-disk-space-tp28681415p28690076.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Browse pgsql-general by date

  From Date Subject
Next Message paladine 2010-05-27 10:21:45 Re: reducing postgresql disk space
Previous Message paladine 2010-05-27 10:21:01 Re: reducing postgresql disk space