Postgres Pro
Downloads
Home   >   mailing lists

Re: new to postgres (and db management) and performance - Mailing list pgsql-performance

From Markus Schaber
Subject Re: new to postgres (and db management) and performance
Date
Msg-id 43CCF235.1080009@logix-tt.com
Whole thread Raw
In response to Re: new to postgres (and db management) and performance already a problem :-(  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Hi, Tom,

Tom Lane wrote:

>>in our db system (for a website), i notice performance boosts after a vacuum
>>full. but then, a VACUUM FULL takes 50min+ during which the db is not really
>>accessible to web-users. is there another way to perform maintenance tasks
>>AND leaving the db fully operable and accessible?
>
> You're not doing regular vacuums often enough.

It may also help to increase the max_fsm_pages setting, so postmaster
has more memory to remember freed pages between VACUUMs.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Next
From: Markus Schaber
Date:
Subject: Re: new to postgres (and db management) and performance