id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
10619	initial indexing of a repository fails (postgres)	anonymous	ejucovy	I just installed MultiRepoSearchPlugin and after following the instructions I got to the following error:\r\n\r\n{{{\r\nomega# trac-admin /var/trac/tcsnp multireposearch reindex_all\r\nRepo  DOES need reindexing\r\nFetching content at development/tcsnp/Makefile.PL\r\n...\r\n...\r\nOperationalError: index row size 7280 exceeds btree maximum, 2713\r\nHINT:  Values larger than 1/3 of a buffer page cannot be indexed.\r\nConsider a function index of an MD5 hash of the value, or use full text indexing.\r\n}}}\r\n\r\nUpon further investigation, it seems this is a pretty common error in PostgreSQL, when trying to index a large TEXT column with a btree-type index:\r\n\r\nhttp://archives.postgresql.org/pgsql-general/2011-03/msg00436.php [[BR]]\r\nhttps://code.djangoproject.com/ticket/14904\r\n\r\nIs this related to the way that MultiRepoSearchPlugin stores data in the schema? (e.g. can it be changed to make it work in Postgres?)\r\n\r\nOr maybe you can use full text indexing (instead of btree-indexing) to achieve the same?	defect	closed	highest	MultiRepoSearchPlugin	blocker	fixed			0.12