| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Subject: | Re: Vacuum questions... |
| Date: | 2005-09-26 15:41:24 |
| Message-ID: | 433816A4.7060202@bigfoot.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Joshua D. Drake wrote:
> Hannu Krosing wrote:
>
>> On L, 2005-09-24 at 20:25 -0700, Joshua D. Drake wrote:
>>
>>
>>
>>> Actually this also probably would not gain you much in 8.1
>>> as vacuum in theory is already dealing with itself.
>>>
>>
>> Interesting. Could you explain it in a more detailed way ?
>> How does vacuum "deal with itself" in 8.1 ?
>>
>>
> Autovacuum is integrated into the backend for 8.1
Can I set the autovacuum parameter per table instead of per
engine ? I'm using pg_autovacuum right now in 7.4 and is not
enough because some tables ( one that implement a materialized
view for example ) are out of an average engine usage and other
tables are so huge to not be analyzed for months.....
Regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-26 15:46:47 | Re: roundoff problem in time datatype |
| Previous Message | Michal Jeczalik | 2005-09-26 15:32:54 | Re: "expected authentication request from server, but |