From: | "Nicola Benaglia" <nico(dot)benaz(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | huge file in pg_xlog and base |
Date: | 2007-07-31 14:27:17 |
Message-ID: | 3526e0707310727vb8385c2t12ed5138061955e5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have 6 little dbs, but I see that my base directory needs 213MB and
log are 114MB.
Here my folder structure and size:
3571 ./base/1
3487 ./base/10792
4691 ./base/10793
3707 ./base/16384
16618 ./base/16386
0 ./base/64673/pgsql_tmp
143697 ./base/64673
0 ./base/86171/pgsql_tmp
6133 ./base/86171
5790 ./base/89667
6401 ./base/106022
7926 ./base/106521
11597 ./base/120343
213615 ./base
160 ./pg_subtrans
0 ./pg_twophase
8 ./pg_multixact/members
8 ./pg_multixact/offsets
16 ./pg_multixact
865 ./global
16 ./pg_clog
0 ./pg_xlog/archive_status
114800 ./pg_xlog
0 ./pg_tblspc
329484 .
Could you please suggest me how to reduce that space (if possible)?
Thank you,
Nico
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-31 14:32:23 | Re: Porting MySQL data types to PostgreSQL |
Previous Message | Tom Lane | 2007-07-31 14:25:45 | Re: Performance problem with large resultsets (byte array 2200) |