Re: [ADMIN] Stopping vacuum

2004-06-29 Thread Tom Lane
Werner Bohl <[EMAIL PROTECTED]> writes: > We have a very big db that was not vacuumed for a long time. We started > vacuum 3 days ago and it has not finished yet. There are some urgent > processes that have to be run against the db. > Is it safe to kill vacuum? It was started with 'vacuum full ana

Re: [ADMIN] Stopping vacuum

2004-06-29 Thread Iain
m: "Werner Bohl" <[EMAIL PROTECTED]> To: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Wednesday, June 30, 2004 2:09 AM Subject: [ADMIN] Stopping vacuum > Hi, > > We have a very big db that was not vacuumed for a long time. We started &g

Re: [ADMIN] Stopping vacuum

2004-06-29 Thread Lee Wu
To speed up, consider to increase vacuum_mem if you have free RAM. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of CHRIS HOOVER Sent: Tuesday, June 29, 2004 10:30 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] Stopping vacuum It is safe

Re: [ADMIN] Stopping vacuum

2004-06-29 Thread CHRIS HOOVER
PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: [ADMIN] Stopping vacuum Hi, We have a very big db that was not vacuumed for a long time. We started vacuum 3 days ago and it has not finished yet. There are some urgent processes that have to be run against the db. Is it safe to

[ADMIN] Stopping vacuum

2004-06-29 Thread Werner Bohl
Hi, We have a very big db that was not vacuumed for a long time. We started vacuum 3 days ago and it has not finished yet. There are some urgent processes that have to be run against the db. Is it safe to kill vacuum? It was started with 'vacuum full analyze' Is there anyway to speed it up at nex