Re: vacuum by non-owner - Mailing list pgsql-general

From Doug McNaught
Subject Re: vacuum by non-owner
Date
Msg-id m3k7e6kle0.fsf@varsoon.wireboard.com
Whole thread Raw
In response to vacuum by non-owner  (Richard Stover <richard@ucolick.org>)
List pgsql-general
Richard Stover <richard@ucolick.org> writes:

> Do I have to run a small program which is setuid to the owner
> of the tables in order to make it possible for the users to
> VACUUM the tables? Or is there a more elegant way to do this?

Why not run 'vacuumdb' periodically out of 'cron' as the postgres
user?

-Doug

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Why no performance boost although I added an index?
Next
From: "Dan Langille"
Date:
Subject: Re: Why no performance boost although I added an index?