| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Still recommending daily vacuum... |
| Date: | 2007-07-03 03:58:18 |
| Message-ID: | 4689C95A.30108@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> "Jim C. Nasby" <decibel(at)decibel(dot)org> writes:
>> http://developer.postgresql.org/pgdocs/postgres/routine-vacuuming.html :
>
> Well, with autovac defaulting to ON in 8.3, that's certainly obsolete
> text now.
>
> Is there a reason to say anything beyond "use autovac"?
Did we change the default autovac parameters for 8.3 (beyond turning it
on?) because on any reasonably used database, they are way to conservative.
Joshua D. Drake
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-07-03 04:11:56 | Re: Still recommending daily vacuum... |
| Previous Message | Tom Lane | 2007-07-03 03:19:12 | Re: Still recommending daily vacuum... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-07-03 04:11:56 | Re: Still recommending daily vacuum... |
| Previous Message | Tom Lane | 2007-07-03 03:26:39 | Re: Load Distributed Checkpoints, final patch |