Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > FWIW this has been fixed in 8.3, you can drop the item from the 8.4 > > queue. Thanks. > > There are a couple of other things on that page that seem already > applied, for instance hashing for numeric and an early form of the > seq

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > FWIW this has been fixed in 8.3, you can drop the item from the 8.4 > queue. Thanks. There are a couple of other things on that page that seem already applied, for instance hashing for numeric and an early form of the seq scan ringbuffer patch. While

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Bruce Momjian
Removed. --- Alvaro Herrera wrote: > 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 d

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-06-10 Thread Alvaro Herrera
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. > ---

Re: [HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-05-16 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Dawid Kuroczko wrote: > Hello, I have a system where there are mostly COPYs, > which insert data into a table. Ocasi

[HACKERS] Stats not updated after rollback -- autovacuum confused.

2007-05-06 Thread Dawid Kuroczko
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 a