[snip]
I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to change it
globally over night
I'm confused, what does statement timeout have to do with this? I was
assuming you would edit autovacuum = off to autovacuum = on wouldn't
that work?
Sorry for the confusion, I was thinking about the procedure of changing
programatically the config file and reload it, all this from a
Csaba Nagy wrote:
[snip]
I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to
Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand
periodically. Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
Autovacuum can be enabled / disabled on the fly using the GUC settings.
Perhaps you can write
Matthew T. O'Connor wrote:
Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand
periodically. Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
Autovacuum can be enabled / disabled on the fly using the GUC
Glen Parker wrote:
Matthew T. O'Connor wrote:
Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand
periodically. Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
Autovacuum can be enabled / disabled on the
On Nov 13, 2006, at 1:05 PM, Glen Parker wrote:
Matthew T. O'Connor wrote:
Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand
periodically. Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature
request :-)
Autovacuum can
Richard Broersma Jr wrote:
Richard Broersma Jr wrote:
Cron yes, vacuumdb no. I would like to AUTO vacuum periodically.
Just curious, what is auto_vacuum going to give that vacuumdb wont?
Hmm, I thought this would be obvious. Vacuumdb just issues VACUUM
commands.
I would like the
You might be able to do that using auto vacuum nap time setting...Thanks,---Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 11/10/06, Glen Parker [EMAIL PROTECTED] wrote:
I would like a way to run the autovacuum daemon on demand periodically. Every night at 2 AM, for example.Anybody know if
I would like a way to run the autovacuum daemon on demand periodically.
Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
-Glen
---(end of broadcast)---
TIP 1: if posting/reading through
On Thu, 2006-11-09 at 17:00 -0800, Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand periodically.
Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
use vacuumdb and cron.
Joshua D. Drake
-Glen
Joshua D. Drake wrote:
On Thu, 2006-11-09 at 17:00 -0800, Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand periodically.
Every night at 2 AM, for example.
Anybody know if this is possible? If not, it's a feature request :-)
use vacuumdb and cron.
Cron yes,
Cron yes, vacuumdb no. I would like to AUTO vacuum periodically.
Just curious, what is auto_vacuum going to give that vacuumdb wont?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Richard Broersma Jr wrote:
Cron yes, vacuumdb no. I would like to AUTO vacuum periodically.
Just curious, what is auto_vacuum going to give that vacuumdb wont?
Hmm, I thought this would be obvious. Vacuumdb just issues VACUUM
commands.
I would like the get the functionality if
Richard Broersma Jr wrote:
Cron yes, vacuumdb no. I would like to AUTO vacuum periodically.
Just curious, what is auto_vacuum going to give that vacuumdb wont?
Hmm, I thought this would be obvious. Vacuumdb just issues VACUUM
commands.
I would like the get the functionality if
or pgsql function should
be prepared on future version??
Regards,
Hitoshi Harada
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Glen Parker
Sent: Friday, November 10, 2006 11:05 AM
To: Postgres General
Subject: Re: [GENERAL] AutoVacuum on demand
Hmm, I thought this would be obvious. Vacuumdb just issues VACUUM
commands.
I would like the get the functionality if autovacuum so that I don't
waste cycles on tables that don't really need vacuuming. However, we've
had bad luck letting autovacuum run on its own terms, so we've
17 matches
Mail list logo