| 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: | Whole Thread | Raw Message | 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) |