[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Vacuum time degrading
From:       Wes <wespvp () syntegra ! com>
Date:       2005-02-28 23:02:04
Message-ID: BE48FF0C.7C01%wespvp () syntegra ! com
[Download RAW message or body]

We've been doing a vacuum every night.  With about 254 million rows, it was
taking abut 0.8 hours.  Now a few months later with about 456 million rows
it is taking 4.8 hours.  I did check the archives and didn't find anything
like this.

Why is the vacuum time not going up linearly?  Since vacuum has to
sequentially read the entire database, I would have expected a linear
increase - about 1.5 hours now.

There are currently no deletes or modifies to the database - only inserts.

This is on PostgreSQL 7.4.5, RedHat ES 3.0.

Wes



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]