| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | me(at)alternize(dot)com |
| Subject: | Re: new to postgres (and db management) and performance |
| Date: | 2006-01-17 13:33:41 |
| Message-ID: | 43CCF235.1080009@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-01-17 13:52:58 | Re: new to postgres (and db management) and performance |
| Previous Message | Andrew Sullivan | 2006-01-17 13:28:59 | Re: new to postgres (and db management) and performance already a problem :-( |