From: | Adam Kavan <akavan(at)cox(dot)net> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_autovacuum |
Date: | 2003-09-02 22:30:47 |
Message-ID: | 5.2.1.1.0.20030902171511.00a533c0@pop.central.cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>So you probabaly want to do somethign like this:
>
>pg_autovacuum -d2 -s1 -S0 -v10 -V0 -a10 -A0 -L pg_autovacuum.out
>
>this will set debug=2, sleep only 1 sec after each look, and perform
>vacuums and analyzes after only 10 insert/update/delets and log it all to
>pg_autovacuum.out
>
>Run your update script
>
>Kill pg_autovacuum
>
>bzip the logfile and send it to the mailing list (or just to me if you
>prefer). Also a copy of your script might help.
>
>Matthew
Ok I ran pg_autovacuum using the supplied command line and have attached
the resulting log. My script is just INSERT INTO "PointUsage"
VALUES(DEFAULT,32,now(),1024); repeated several thousand times. I ran
autovac, then my script, then verified all of the rows were inserted then
ran DELETE FROM "PointUsage" WHERE "Value" = 1024; to kill all of the new
rows, and then killed autovac. The results are attached.
Thank you very much for taking the time to look at this for me.
--- Adam Kavan
--- akavan(at)cox(dot)net
Attachment | Content-Type | Size |
---|---|---|
pg_autovacuum.out.bz2 | application/octet-stream | 3.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | John Velman | 2003-09-02 23:09:00 | Comparing dates |
Previous Message | Marc G. Fournier | 2003-09-02 22:26:49 | Re: YOUR SITES SEARCH FEATURE DOES NOT WORK! |