Re: pg_attribute

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Andrew Bartley <abartley(at)evolvosystems(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_attribute
Date: 2002-09-24 09:09:21
Message-ID: 20020924090921.GD21640@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 24, 2002 at 04:22:04PM +1000, Andrew Bartley wrote:
> It takes a long time to vacuum this table... Both "vacuum" and "vacuum
> full".
>
> It does not appear to be a big table. Can I speed it up somehow?

Paste the output of VACUUM VERBOSE ANALYSE.

Thanks,

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2002-09-24 09:16:20 Re: [GENERAL] CURRENT_TIMESTAMP
Previous Message Martijn van Oosterhout 2002-09-24 09:08:13 Re: Output format revisited - booleans