--- Richard Broersma Jr <rabroersma@xxxxxxxxx> 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=>
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
