Devrim GÜNDÜZ wrote:
(Why are you using VACUUM FULL? It has been considered harmful, at least
for a regular maintenance job.)
We should point everyone using VACUUM FULL like Janet to read
http://wiki.postgresql.org/wiki/VACUUM_FULL
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL T
On 06/22/10 8:44 PM, Janet Jacobsen wrote:
Hi. Is it possible to vacuum a table (vacuum full analyze)
from a script. Currently I run the Postgres client and then
run vacuum, but I'd like to automate the vacuum by calling
it from a (Perl) script.
postgres since 8.1 has had autovacuum, autovacu
On Tue, 2010-06-22 at 20:44 -0700, Janet Jacobsen wrote:
> Is it possible to vacuum a table (vacuum full analyze)
> from a script.
Use vacuumdb command.
(Why are you using VACUUM FULL? It has been considered harmful, at least
for a regular maintenance job.)
--
Devrim GÜNDÜZ
PostgreSQL Danışma
On 23/06/10 13:44, Janet Jacobsen wrote:
Hi. Is it possible to vacuum a table (vacuum full analyze)
from a script. Currently I run the Postgres client and then
run vacuum, but I'd like to automate the vacuum by calling
it from a (Perl) script.
see attached for example.
vacuum.pl
Description
