In response to "Laurent Raufaste" <[EMAIL PROTECTED]>: > 2008/3/21, Gregory Stark <[EMAIL PROTECTED]>: > > > > Well that's true it does. But only once per row. So analyze would have set > > the > > bit on every row. You could do the same thing with something ligter like > > "select count(*) from <table>". > > Well, the table has been analyzed, I did SELECT, PG write on the > table. That's a fact. > > But it's also true (I juste tested it) that every file of a table is > modified by a SELECT COUNT.
The real question (to verify Tom's point) is does a _second_ SELECT count() modify the table again? If so, then something else is going on than what Tom suggested. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance