Re: Unexpectedly high disk space usage - Mailing list pgsql-general

I followed your example, the result is at the bottom. Based on this it
would seem that there are 3-4 databases that seem to be the culprit. How
could I get more depth/detail on what specifically is the problem?

-Ben

On 11/05/2012 07:10 PM, Scott Marlowe wrote:
> What does du -sh have to say about it? Use unix tools to examine your
> file system and see where the usage is going. For instance, I can do
> this: cd /var/lib/postgresql/8.4/main/ du -s *|sort -n 0 server.crt 0
> server.key 4 pg_tblspc 4 pg_twophase 4 PG_VERSION 4 postmaster.opts 4
> postmaster.pid 12 pg_clog 12 pg_stat_tmp 12 pg_subtrans 28
> pg_multixact 460 global 16392 pg_xlog 16396 base which tells me that
> I'm using about 16MB for each pg_xlog and base. I can then do cd into
> base and look around: cd base du -s *|sort -n 5416 1 5416 11563 5560
> 11564 Which shows me using about 5MB each for three different dbs. And
> so on. On an off guess, did you go from a SQL_ASCII encoding to UTF8?
> That might increase disk space usage a bit.

[root@delta ~]# cd /var/lib/pgsql/9.1/data/
[root@delta data]# du -s * | sort -n
4       pg_ident.conf
4       pg_serial
4       pg_tblspc
4       PG_VERSION
4       postmaster.opts
4       postmaster.pid
8       pg_hba.conf
12      pg_notify
12      pg_twophase
20      postgresql.300
20      postgresql.conf
20      postgresql.conf.20120903
20      postgresql.conf.300
76      pg_subtrans
104     pg_multixact
15044   pg_log
18184   global
25216   pg_stat_tmp
47916   pg_clog
671916 pg_xlog
164753204       base

[root@delta data]# cd base
[root@delta base]# du -s * | sort -n
4       pgsql_tmp
6124    12772
6388    12780
6424    1
72424   331506
72700   160676
72896   391655
73200   52389
73216   523672
74104   619675
74956   295646
76768   307580
77896   547597
80824   571547
87368   475799
90940   631604
113876  124651
123548  148525
130096  367533
149792  439726
173648  355578
175404  679545
190732  559580
225780  511706
326468  667547
352736  655477
398736  535644
469408  136582
483716  499753
513124  270926
575612  715601
590408  487780
666604  463779
713208  643540
714896  583515
803216  343438
806952  427663
855156  739506
872200  197221
975692  64371
987692  775594
1005268 595488
1024812 691482
1042212 727552
1047464 379566
1260044 76601
1276756 16384
1345072 403667
1474468 209158
1477808 172604
1536168 221124
1637652 258798
1811504 88598
1963740 245588
2076748 703467
2193536 415671
2430908 801322
2552640 319552
2785212 28315
3454880 112612
3755548 451666
3929420 100666
4651876 40451
5714940 751514
6257740 233293
7313900 184735
9334796 763606
10940780        283609
20837264        788338
45285640        607471