Skip site navigation (1) Skip section navigation (2)

7.1 vacuum

From: "Magnus Naeslund\(f\)" <mag(at)fbab(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.1 vacuum
Date: 2001-04-27 04:10:44
Message-ID: 062601c0ced0$07e9b4d0$020a0a0a@totalmef (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
How does 7.1 work now with the vacuum and all?

Does it go for indexes by default, even when i haven't run a vacuum at all?
Does vacuum lock up postgres? It says the analyze part shouldn't, but how's
that for all of the vacuum?

An 7.0.3 db we have here we are forced to run vacuum every hour to get an
acceptable speed, and while doing that vacuum (5-10 minutes) it totaly
blocks our application that's mucking with the db.

Just curious

Magnus Naeslund


pgsql-hackers by date

Next:From: Vadim MikheevDate: 2001-04-27 04:18:40
Subject: Re: 7.1 startup recovery failure
Previous:From: Hiroshi InoueDate: 2001-04-27 04:07:38
Subject: 7.1 startup recovery failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group