From: G. Anthony Reina <reina@nsi.edu>
To: Jason Slagle <raistlin@tacorp.net>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] Performance
Date: Wed, 10 Mar 1999 18:44:30 +0000
Message-ID: <36E6BD8E.F0B7B4B3@nsi.edu> (raw)
References: <Pine.LNX.4.03.9903101327030.20770-100000@tacorp.net>
Jason Slagle wrote:
> And how long is normal for Vacuum analyze to take on bout 350 megs of
> DATA?
>
> Jason
>
My database is 1.4 Gig. It takes about 2-3 minutes for a vacuum analyze verbose.
I have had problems in the past with a corrupted main index (the table of
tables). In such a case, the vacuum never stops even after > 48 hours. Try
vacuuming your tables one-by-one if you have really long vaccums (> 1 hour). If
the tables vacuum one-by-one alright, then you have a corrupted main index.
-Tony
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: reina@nsi.edu, raistlin@tacorp.net, pgsql-sql@hub.org
Subject: Re: [SQL] Performance
In-Reply-To: <36E6BD8E.F0B7B4B3@nsi.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox