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@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
