Postgres Pro
Downloads
Home   >   mailing lists

Re: Does SET STATISTICS lock the table? - Mailing list pgsql-general

From Tom Lane
Subject Re: Does SET STATISTICS lock the table?
Date
Msg-id 14307.1075618614@sss.pgh.pa.us
Whole thread Raw
In response to Does SET STATISTICS lock the table?  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Tree view 
Joseph Shraibman <jks@selectacast.net> writes:
> 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.

Any ALTER TABLE will lock the table.

            regards, tom lane

pgsql-general by date:

Previous
From: "Merrall, Graeme"
Date:
Subject: Search across multiple sources
Next
From: Oleg Bartunov
Date:
Subject: Re: Search across multiple sources