| From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: server space increasing very fast but transaction are very low |
| Date: | 2008-11-06 10:57:27 |
| Message-ID: | 20081106105727.GC554@easy2.in-chemnitz.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Hi,
On Thu, Nov 06, 2008 at 04:15:02PM +0530, brahma tiwari wrote:
> My database server db01 is on linux environment and size of base folder increasing very fast unexpectedly(creating renamed files of 1 GB in base folder like 1667234568.10)
This sounds like your max_fsm_pages setting is too low, so the server
cannot track free pages any more
Bump it up (there used to be a rule of thumb, IIRC it was 65536/1 GB of
data/disk space - please correct me, if I'm wrong).
IIRC, you need to restart PostgresSQL after altering that setting. A
VACUUM is prbably a good thing as well, maybe even VACUUM FULL. Do not
delete anything!
HTH,
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-11-06 11:04:30 | Re: server space increasing very fast but transaction are very low |
| Previous Message | brahma tiwari | 2008-11-06 10:45:02 | server space increasing very fast but transaction are very low |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-11-06 11:04:30 | Re: server space increasing very fast but transaction are very low |
| Previous Message | Віталій Тимчишин | 2008-11-06 10:46:47 | Re: PostgreSQL OR performance |