manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aeham Abushwashi <aeham.abushwa...@exonar.com>
Subject Re: Scaling in MCF
Date Thu, 13 Nov 2014 14:44:30 GMT
Looking at the 9.2 postgresql docs on REINDEX (
http://www.postgresql.org/docs/9.2/static/sql-reindex.html),I think you're
right in that it's not strictly necessary as an ongoing operation but that
it may help performance a little by reducing bloat and grouping pages
together (http://www.postgresql.org/docs/9.2/static/routine-reindex.html).
Perhaps it's useful for Manifold to have the ability to invoke REINDEX but
that it should just do it less often?

I'll look into this a bit more and also keep a closer watch on REINDEXing
activity in the upcoming tests...

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message