On Mon, May 31, 2010 at 3:42 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > note that at no time do we have any FSM > data for the bid table: > > > 3. After awhile, autovacuum notices all the insert activity and kicks > off an autoanalyze on the bid table. When committed, this forces a > relcache flush for each other backend's relcache entry for "bid". > In particular, the smgr targblock gets reset.
This is an analyze-only scan? Why does analyze need to issue a relcache flush? Maybe we only need to issue one for an actual vacuum which would also populate the fsm? -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
