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

Re: Long Running Update

From: Harry Mantheakis <harry(dot)mantheakis(at)riskcontrollimited(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Claudio Freire <klaussfreire(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Long Running Update
Date: 2011-06-24 16:49:55
Message-ID: 4E04C033.8060305@riskcontrollimited.com (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-performance by date

Next:From: Shaun ThomasDate: 2011-06-24 18:55:47
Subject: Re: Cost of creating an emply WAL segment
Previous:From: Kevin GrittnerDate: 2011-06-24 16:41:38
Subject: Re: Long Running Update

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