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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
