Shaozhong SHI <shishaozhong@gmail.com> writes:
> Locked tables stop progress.
> How to explicitly preventing locking?
You are really wasting everybody's time, including yours,
with these detail-free questions. The short answer to the
question as stated is "you can't". There is probably some
more-useful answer that could be given, but we'd need to
understand a lot more about what your actual problem is.
There is some advice about how to ask useful questions at
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
regards, tom lane