On Wed, 28 Jan 2009, Ivan Sergio Borgonovo wrote:
On Tue, 27 Jan 2009 20:45:53 +0300
Teodor Sigaev <teodor@xxxxxxxxx> wrote:
No matter if I drop the trigger that update agg content and the
fact that I'm just updating d, postgresql will update the index?
Yes, due to MVCC. Update of row could produce new version (tuple)
and new version should be index as old one.
Does that mean that it could be a good choice to place the tsvector
in another table?
this is a trade-off - additional join
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
