huge file in pg_xlog and base - Mailing list pgsql-general

From Nicola Benaglia
Subject huge file in pg_xlog and base
Date
Msg-id 3526e0707310727vb8385c2t12ed5138061955e5@mail.gmail.com
Whole thread Raw
Responses Re: huge file in pg_xlog and base
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance problem with large resultsets (byte array 2200)
Next
From: Tom Lane
Date:
Subject: Re: Porting MySQL data types to PostgreSQL