Re: Table Vacuum Taking a Long Time

From: Hannes Erven <hannes(at)erven(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Table Vacuum Taking a Long Time
Date: 2014-04-02 15:46:32
Message-ID: 533C30D8.5040704@erven.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Eliot,

> If I continue to run vacuum
> analyze on it, it continues to take about 90 seconds each time.
> [..]
> I was under the impression that if nothing had been done to the table
> since it was last vacuumed, that it would return immediately.

in addition to what others already said, I'd expect that by specifying
ANALYZE you are forcing PostgreSQL to do quite expensive additional work.

Is there a reason why you cannot (or do not want to) rely on
autovaccuum? Have you tried tuning the parameters?

Even if you must use manual VACUUMs, you can probably get away without
ANALZE.

Best regards,

-hannes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-04-02 15:49:28 Re: Lock problem
Previous Message Tom Lane 2014-04-02 15:31:13 Re: Lock problem