"Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > I have master table A, inherited by Table B and Table C > Does the truncation of a child table take a lock on the master table ? No, but it certainly locks the child table ... and queries on A are going to try to scan all three tables. regards, tom lane