Re: Really slow UPDATE and DELETE

Поиск
Список
Период
Сортировка
От Nicholas Piper
Тема Re: Really slow UPDATE and DELETE
Дата
Msg-id 20010731234104.B18670@piamox7.haus
обсуждение исходный текст
Ответ на Re: Really slow UPDATE and DELETE  (Ryan Mahoney <ryan@paymentalliance.net>)
Список pgsql-general
> >I'm going to turn up debugging in case that will allow me to see all
> >the work PG is putting into my title UPDATE.

I did this, and it turns out my fti trigger is doing work which
doesn't use recommended (string,id) index in the fti docs. I've added
one on just id and it all flies again !

Thanks for your help,

 Nick

--
Part 3 MEng Cybernetics; Reading, UK       http://www.nickpiper.co.uk/
Change PGP actions of mailer or fetch key see website   1024D/3ED8B27F
Choose life. Be Vegan :-) Please reduce needless cruelty + suffering !

В списке pgsql-general по дате отправления:

Предыдущее
От: Ryan Mahoney
Дата:
Сообщение: Re: Really slow UPDATE and DELETE
Следующее
От: will trillich
Дата:
Сообщение: Re: RULE vs TRIGGER