Hi all,
we are currently developping a "real time" telemetry system. We use
postgresql to store each measures. This measures represents around 350
inserts each 5 minutes (this is a 24/7 system). As we saw, performance
is really dependant on vacuum analyze operations and we would like to
keep the same level of performance as long as possible.
So we would like to do such a vacuum analysis daily (is it really
necessary ?). My question is more based on real experience you could
have had on projects involving such a system to tell me how often vacuum
analyze on critiacl tables should be done. Does it "locks" the table or
is it possible to keep on inserting while vacuuming with small insert
speed loss?
Thank you in advance!
--
Jean-Christophe ARNU
s/w developer
Paratronic France