=?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@xxxxxxxxxx> writes: > That is strange for me. VACUUM updates pg_class.reltuples differently (only > live roiws count) than autovacuum (live and dead rows). Why? I don't have time to poke into this in detail right now, but I think that more likely the issue is that ANALYZE might have a different rule than VACUUM. autovacuum will fire those operations independently, which doesn't match what you're doing by hand. Which is not to say that we shouldn't think about fixing that, but that it's important to understand the problem clearly first. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
