Re: very long update gin index troubles back? - Mailing list pgsql-general

Ответишь ему что-нибудь? Он так мутно излагает, что я ни хрена не понял.

Ivan Sergio Borgonovo wrote:
> I've a table that contain a tsvector that is indexed (gin) and
> triggers to update the tsvector that should then update the index.
>
> This gin index has always been problematic. Recreation and updates
> were very slow.
>
> Now I had to update 1M rows of that table but for columns
> that doesn't involve the tsvector
> I dropped the trigger to update the tsvector so that when rows get
> updated the trigger won't be called so things should be faster...
> but still it is taking forever.
>
> begin;
>         set constraints all deferred;
>
>         select * from FT1IDX_trigger_drop();
>         update catalog_items set
>         APrice=p.PrezzoA,
>         BPrice=p.PrezzoB
>         from import.catalog_prices p where
>         catalog_items.ItemID=p.id;
>     select * from FT1IDX_trigger_create();
> commit;
>
> function are used since I've 2 triggers actually that I drop and
> create.
>
> Is there anything wrong in the above to make this update so slow on
> a 2x Xeon 3.2GHz 4GbRAM and a RAID1 [sic] I know it is slow on write.
>
>

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/