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

Re: unreasonable run time for vacuum analyze?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: David Monarchi <david(dot)e(dot)monarchi(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: unreasonable run time for vacuum analyze?
Date: 2007-06-13 00:25:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
--- David Monarchi <david(dot)e(dot)monarchi(at)gmail(dot)com> wrote:

> Hello -
> I'm running 8.2.3 on an 8-processor Linux box with a fiber-optic SAN.
> One table in the database contains 22.6M rows of 71 fields with an average
> length of about 500 bytes.  The table is in BCNF.  The table is queried in a
> wide variety of ways.  There are 37 btree and Gin indexes defined on the
> table.  The GIN indexes are on array fields.  The rest are btree.
> I started running vacuum analyze on this table over 44 hours ago, and it is
> still running.  The load on the machine has been modest.  There have been no
> times when all eight processors were being used.
> 1) is this amount of time reasonable?
> 2) if I abort the vacuum analyze, will I corrupt the table, its indexes, or
> the database?
> 3) are there parameters that I can set to improve the performance of the
> vacuum analyze process?

If you don't get an answer very quickly, you might want to repost this message on the postgresql
performance list.

Richard Broersma Jr.

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2007-06-13 00:51:09
Subject: Re: Joins within a table
Previous:From: David MonarchiDate: 2007-06-13 00:04:01
Subject: unreasonable run time for vacuum analyze?

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