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