Re: ADD COLUMN ts tsvector GENERATED too slow

On 06.07.22 10:42, Florents Tselai wrote:
> I have a beefy server (40+ worker processes , 40GB+ shared buffers) and a table holding (key text, text text,) of
around50M rows.
 
> These are text fields extracted from 4-5 page pdfs each.
> 
> I’m adding the following generated col to keep up with tsvectors
> 
> ALTER TABLE docs_text ADD COLUMN ts tsvector GENERATED ALWAYS AS (to_tsvector(’simple', left(text, 1048575))) STORED
> 
> I expect this to be slow, but it’s been running for 18hrs already and I certainly hope I’ve done something wrong and
there’sa smarter way.
 

Maybe it's stuck on a lock?  ALTER TABLE / ADD COLUMN requires an 
exclusive lock on the table.