| From: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
|---|---|
| To: | Florents Tselai <florents(dot)tselai(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ADD COLUMN ts tsvector GENERATED too slow |
| Date: | 2022-07-06 09:38:22 |
| Message-ID: | 155880bb-f9d7-a34b-664b-61763b6e8719@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 around 50M 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’s a smarter way.
Maybe it's stuck on a lock? ALTER TABLE / ADD COLUMN requires an
exclusive lock on the table.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2022-07-06 09:40:22 | Re: unable to understand query result |
| Previous Message | Stefan Froehlich | 2022-07-06 09:31:20 | unable to understand query result |