Vacuum and 24 hour availability - Mailing list pgsql-general

From Bryan Willett
Subject Vacuum and 24 hour availability
Date
Msg-id Pine.LNX.4.21.0007050901380.32530-100000@xlord.dunsinane.net
Whole thread Raw
List pgsql-general
I'm using PostgreSQL for an online game (www.merchantempires.net).

Running Vacuum analyze locks down the database. Unfortunately,
its a little disconcerting to my players when this occurs.
I've got people playing 24 hours a day.

My question is how can PostgreSQL ever be used for a database
that needs to be available 24/7, if running a vacumm locks
it down?

I like PostgreSQL but if there is no way around this rather
significant feature (bug?) then I will have to switch to
something else.

Please forward replies to: bryan@dunsinane.net

Thanks


pgsql-general by date:

Previous
From: "Robert D. Nelson"
Date:
Subject: RE: responses to licensing discussion
Next
From: Peter Mittermayer
Date:
Subject: psotgresql history function