All Posts For: PostgreSQL

Nov 28 2005

Lowering the priority of a PostgreSQL query

When maintaining a large database system that requires high availability, there are times when you want to run some maintenance queries without impacting the performance of other users accessing the database. A nightly script that cleans up old data or updates cached calculations is a good example: the maintenance should be performed, but not at the expense of other connected users.…