I presented a talk about PostgreSQL performance in the amaGama project today at South Africa’s Postgres Conference. The talk gave some background about translation memory systems and covered how the amaGama project uses PostgreSQL’s full-text functionality.
As you can read in the summary, I managed to make a vast improvement to the databasis performance. Users of our hosted instance have already benefited from the improved performance for the last few weeks.
An interesting aspect of this work is how the partially overlapping partial indexes are complemented by the better physical layout on disk (achieved by the CLUSTER command). The performance is improved in the case of both hot and cold disk cache.
I trust a video will be made available in due course. Congratulations to the organizers on a very nice event!