| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Pallav Kalva <pkalva(at)livedatagroup(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, Mark Lewis <mark(dot)lewis(at)mir3(dot)com> |
| Subject: | Re: 8.2 Autovacuum BUG ? |
| Date: | 2007-08-31 18:51:28 |
| Message-ID: | 20070831185128.GM8046@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Pallav Kalva wrote:
> My main concern is filling up my disk with archive logs, so from all the
> replies I get is that since tuples are already frozen, next time when it
> runs autovacuum it wont generate any archive logs.
>
> Is my assumption right ?
Well, it won't generate any logs for the tuples that were just frozen,
but it will generate logs for tuples that weren't frozen. How many of
these there are, depends on how many tuples you inserted after the batch
that was just frozen.
If you want to freeze the whole table completely, you can you VACUUM
FREEZE.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-31 19:08:45 | Re: 8.2 Autovacuum BUG ? |
| Previous Message | Alvaro Herrera | 2007-08-31 18:47:44 | Re: 8.2 Autovacuum BUG ? |