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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org