Re: Long Running Update - Mailing list pgsql-performance

From Harry Mantheakis
Subject Re: Long Running Update
Date
Msg-id 4E04C033.8060305@riskcontrollimited.com
Whole thread Raw
In response to Re: Long Running Update  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
I called VACUUM on the database after abandoning the original all-in-one
update.

And I have a daily cron script that executes the following statement:

sudo -u postgres /usr/bin/vacuumdb -U postgres --all --analyze

But I had not considered using CLUSTER - I will certainly look into that.

Thanks again.

Harry Mantheakis
London, UK


pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Long Running Update
Next
From: Shaun Thomas
Date:
Subject: Re: Cost of creating an emply WAL segment