[GENERAL] permissions question

Suppose we have table A and table B. When action is performed on table A (for example INSERT), some action (for example UPDATE) through the trigger is done on table B. If user had permission on both tables (GRANT INSERT on table A and GRANT UPDATE on table B)- everything is good. But in that way

[GENERAL] rotating table question

Suppose we have table with indexes, attached triggers, and finnaly alot of records (more then 100,000). Records are adding continuously. Once a month you have to do archiving of records. Simple INSERT INTO ARCHIV followed by DELETE and then VACUUM take alot of time, offen even hang up sessions. D

[GENERAL] small question

Suppose we have table A and table B. When action is performed on table A (for example INSERT), some action (for example UPDATE) through the trigger is done on table B. If user had GRANT permission on both tables - everything is good. But in that way user can get access to table B directly. If I