Does SET STATISTICS lock the table?

Does ALTER TABLE <table> ALTER <field> SET STATISTICS 100; lock the
table? I just tried to do that while a query is running and the ALTER
is hanging.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

re: Does SET STATISTICS lock the table?

Joseph Shraibman <jks@selectacast.net> writes:[color=blue]
> Does ALTER TABLE <table> ALTER <field> SET STATISTICS 100; lock the
> table? I just tried to do that while a query is running and the ALTER
> is hanging.[/color]

Any ALTER TABLE will lock the table.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org