| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | Bealach-na Bo <bealach_na_bo(at)hotmail(dot)com>, ahodgson(at)simkin(dot)ca, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Why so slow? |
| Date: | 2006-05-02 17:16:12 |
| Message-ID: | 445793DC.40401@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Bill,
Bill Moran wrote:
> My understanding is basically that if you vacuum with the correct
> frequency, you'll never need to vacuum full. This is why the
> autovacuum system is so nice, it adjusts the frequency of vacuum according
> to how much use the DB is getting.
Additonally, the "free_space_map" setting has to be high enough, it has
to cover enough space to put in all pages that get dead rows between two
vacuum runs.
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 | Jim C. Nasby | 2006-05-02 17:16:17 | Re: Slow restoration question |
| Previous Message | Jim C. Nasby | 2006-05-02 17:14:58 | Re: Easy question |