| From: | Alessandro Gagliardi <alessandro(at)path(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | set autovacuum=off |
| Date: | 2012-02-22 23:50:57 |
| Message-ID: | CAAB3BBLsZ94tTzaiTZrdpK+2m1waj8=VL31aPvOGFJ7oAGCHiQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I have a database where I virtually never delete and almost never do
updates. (The updates might change in the future but for now it's okay to
assume they never happen.) As such, it seems like it might be worth it to
set autovacuum=off or at least make it so vacuuming hardly ever occurs.
Actually, the latter is probably the more robust solution, though I don't
know how to do that (hence me writing this list). I did try turning
autovacuum off but got:
ERROR: parameter "autovacuum" cannot be changed now
SQL state: 55P02
Not sure what, if anything, I can do about that.
Thanks,
-Alessandro
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reuven M. Lerner | 2012-02-23 08:39:49 | Very long deletion time on a 200 GB database |
| Previous Message | Alessandro Gagliardi | 2012-02-22 00:11:04 | Re: Indexes and Primary Keys on Rapidly Growing Tables |