PDA

View Full Version : Postgres question



mphh
04-03-2012, 09:20 AM
I need to get my postgres as fast as possible and i wonder if there is any difference between vacuum/reindexing in hem2 or in postgres direct.

When i do the process in hem2 it is pretty fast,even when i do a full vacuum.that makes me think if it is as efficient as doing it direct in postgres

So my thoughts are,that it maybe better to do it in postgres to get an even better result?

My database is about 30 gigs

Patvs
04-03-2012, 09:59 PM
Just vaccuum/analyse/reindex in pgadminIII. (since you can see errors if something goes wrong)
In HM2 the same thing is performed.