[DONE] Suggestion: Could you add vacuum & reindex DB into Elephant after DB update?

    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,745
      Hi all.

      I think that Elephant could vacuum & reindex DB after update because it really shortens import time at Elephant startup.
      Just look at the screenshot:






      1) Import duration in new DB
      2) Import duration at second Elephant startup
      3) Import duration after vacuum & reindex DB.
  • 6 replies
    • mrk1988
      mrk1988
      Bronze
      Joined: 04.02.2007 Posts: 13,337
      I'll forward this thread to my colleagues - as always :)
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Hi Stanisluv,

      we'll have to verify these results, but nevertheless an automatic DB maintenance task right before the AutoUpdateImport seems to be a pretty good idea anyway, I'll set it onto the agenda...

      Cheers,
      L
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Stanisluv? It seems that you haven't deleted the Database before you reimported the files again?
      Duplicates will be identified and handled before an import task takes place...
      You have to reset your database and import the very same data again to get a valid and comparable value for the whole import duration.

      Cheers,
      L
    • stanisluv
      stanisluv
      Moderator
      Moderator
      Joined: 18.06.2008 Posts: 45,745
      Ok. I try to explain what I did step by step:
      1) I purge DB.
      2) Import all files in DB.(1)
      3) Close Elephant
      4) Start Elephant & look at import time(2)
      5) Close Elephant
      6) Go to Start\All programs\PostgreSQL 8.3\pgAdmin 8.3
      7) Connect to server.
      8) Vacuum & Reindex current DB(For more details look at the sreenshot)


      9) Start Elephant & look at import time again (3)
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      Thanks for clarification, we think about adding maintenace tasks like Vaccum and Reindex to Elephant's automated update import.

      Thx,
      L
    • Larres
      Larres
      Bronze
      Joined: 07.09.2009 Posts: 2,402
      We've added this feature into our product backlog and will improve the Elephant with it later on.

      Thx,
      L