Robert Haas <robertmh...@gmail.com> writes: > I'm wondering if this problem could be solved with a sort of > mark-and-sweep garbage collection: >... > Then you can write something which goes through and sets all the rows > to false and then visits every row of every table in the database and > forces OID lookups on the security ID of each. When you get done, any > rows that still say false are unreferenced and can be killed.
This sounds awfully similar to the bitmap index vacuum problem. I wonder if security labels could be implemented as some kind of funky special index. Just thinking out loud. I don't have a well-formed idea based on this. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers