Re: update functions locking tables - Mailing list pgsql-general

From Clodoaldo Pinto
Subject Re: update functions locking tables
Date
Msg-id a595de7a05083009006016da49@mail.gmail.com
Whole thread Raw
In response to Re: update functions locking tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
2005/8/30, Alvaro Herrera <alvherre@alvh.no-ip.org>:
> On Tue, Aug 30, 2005 at 10:18:20AM -0300, Clodoaldo Pinto wrote:
> > A vacuum full or a cluster is totally out of reach since each take
> > about one hour.
>
> Even if you cluster/vacuum only the just-loaded table?
>

No, that would  be much faster. The biggest just updated is about 600
thousand rows. I will consider it.

> > The biggest table is 170 million rows long.
>
> I hope this is not the one you are loading daily ...
>
I load daily 8 times 700+ thousand rows.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: detection of VACUUM in progress
Next
From: Michael Fuhr
Date:
Subject: Re: detection of VACUUM in progress