From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Windows Auto-Vacuum in 8.2.4 or 8.2.5 |
Date: | 2007-09-21 15:02:06 |
Message-ID: | 489987.74336.qm@web31803.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> I will dis-able the hourly manual vacuum/analyze script that I implemented as a work-around to
> this problem to see if auto-vacuum is ever triggered.
it appears to be working fine in 8.2.5:
proj02u20411=> begin transaction;
BEGIN
proj02u20411=> update document set docdisc = docdisc;
UPDATE 7927
proj02u20411=> update document set docnum = docnum;
UPDATE 7927
proj02u20411=> rollback;
ROLLBACK
proj02u20411=> explain analyze select count(*) from docs.document;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
Aggregate (cost=641.58..641.59 rows=1 width=0) (actual time=25.340..25.341 rows=1 loops=1)
-> Seq Scan on document (cost=0.00..587.26 rows=21726 width=0) (actual time=0.025..14.578
rows=7927 loops=1)
Total runtime: 25.508 ms
(3 rows)
proj02u20411=> \x
Expanded display is on.
proj02u20411=> SELECT *
proj02u20411-> FROM Pg_stat_all_tables
proj02u20411-> WHERE schemaname = 'docs'
proj02u20411-> AND relname = 'document'
proj02u20411-> ORDER BY schemaname, relname;
-[ RECORD 1 ]----+---------------------------
relid | 16867
schemaname | docs
relname | document
seq_scan | 4769
seq_tup_read | 34099275
idx_scan | 452899
idx_tup_fetch | 1679315
n_tup_ins | 59
n_tup_upd | 15868
n_tup_del | 52
last_vacuum | 2007-09-21 07:00:03.646-07
last_autovacuum | 2007-09-21 07:57:49.496-07
last_analyze | 2007-09-21 07:00:03.646-07
last_autoanalyze | 2007-09-21 07:57:49.496-07
proj02u20411=> \x
Expanded display is off.
proj02u20411=> explain analyze select count(*) from docs.document;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
Aggregate (cost=234.09..234.10 rows=1 width=0) (actual time=22.014..22.016 rows=1 loops=1)
-> Seq Scan on document (cost=0.00..214.27 rows=7927 width=0) (actual time=0.025..11.490
rows=7927 loops=1)
Total runtime: 22.140 ms
(3 rows)
proj02u20411=>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-09-21 15:04:10 | Re: Using RETURNING with INTO inside pgsql |
Previous Message | Richard Broersma Jr | 2007-09-21 14:49:48 | Re: Windows Auto-Vacuum in 8.2.4 or 8.2.5 |