Re: Stats not updated after rollback -- autovacuum confused.

Bruce Momjian escribió:
> 
> This has been saved for the 8.4 release:
> 
>     http://momjian.postgresql.org/cgi-bin/pgpatches_hold

FWIW this has been fixed in 8.3, you can drop the item from the 8.4
queue.  Thanks.


> ---------------------------------------------------------------------------
> 
> Dawid Kuroczko wrote:
> > Hello, I have a system where there are mostly COPYs,
> > which insert data into a table.  Ocasionally a COPY will fail (and thus,
> > dead rows appear), but as far as I can tell ROLLBACK is not reflected
> > anywhere in the pg_stats_user_tables.  And since there are no rows
> > n_tup_upd or n_tup_del, therefore autovacuum will not fire for that table.


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support