| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Buglist |
| Date: | 2003-08-22 14:01:27 |
| Message-ID: | 20030822140127.GA27885@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, Aug 22, 2003 at 12:17:41 +0530,
Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
>
> Idea of autovacuum is to reduce load on vacuum full. If you set shared_buffers
> higher and FSM properly for he update/delete load, autovacuum is expected to
> catch most of the dead tuples in shared cache only. If it is successful in
> doubling the frequency on vacuum full, that's a big win, isn't it?
If you run a normal vacuum often enough, you shouldn't need to regularly
run vacuum full.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-22 14:07:05 | Re: Postgresql for Solaris on Sparc |
| Previous Message | javier garcia - CEBAS | 2003-08-22 13:56:33 | pgAdminII Error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-08-22 14:09:44 | Re: Buglist |
| Previous Message | Frank van Vugt | 2003-08-22 13:12:07 | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 |